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
800
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!