Hello Everyone,
I am new to excel macros. Can someone help me with a code to get each column value in excel till the end column. Thanks in advance!!
The sheet looks like this:
A B C D E F G H
1 2 3 4 5 6 7 8 9
2 3 4 5 6 7 8 9 0
Where A, B, C etc are column names/values
I want the code to traverse till last column (which is H here) untill its null and then fetch the column value in a msgbox or text file
Thanks!!
Bookmarks