VBA to copy a formula in a cell x amount times horizontally based on value in another cell

[WingchairAndy]

Not a strong VBA user

I have a formula in Cell B3, I need to copy this using VBA x amount of times horizontally to the right, x = the value in Cell B2. This will change each time hence the value in B2

Any help would be appreciated.

Regards

Andrew

 

[Peter_SSs]

Is this what you mean?

Sub Copy_Formula()
  Range("B3").Copy Destination:=Range("C3").Resize(, Range("B2").Value)
End Sub

 

[WingchairAndy]

Peter

Many thanks for this - it worked a treat, really appreciate your quick response

Regards

Andrew

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.