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.

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
awesome thank you so much.