Simple macro [Solved/Closed]

Report
Posts
1
Registration date
Thursday February 6, 2014
Status
Member
Last seen
February 6, 2014
-
 warnerjs -
I am trying to create a Macro to filling in a series of columns starting with the current cell.



simply if cell A1 is selected and you hit the macro the cells a1 through A35 are filled in with an X.

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
Sub test()
Range(Selection, Selection.Offset(34, 0)).FormulaArray = "X"

End Sub
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

awesome thank you so much.