Simple macro

Solved/Closed
warnerjs Posts 1 Registration date Thursday February 6, 2014 Status Member Last seen February 6, 2014 - Feb 6, 2014 at 01:42 PM
 warnerjs - Feb 7, 2014 at 03:21 PM
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.
Related:

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 6, 2014 at 11:12 PM
Sub test()
Range(Selection, Selection.Offset(34, 0)).FormulaArray = "X"

End Sub
2
awesome thank you so much.
0