How to get each column value till end of list

[newcomer11]

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!!

[shekhar1660]

Hi,

Are you looking for any VBA code?
If Yes, please provide your excel version 2003 or 2007?

[Alf]

Perhaps a macro like this?

Please Login or Register  to view this content.

Will save values to to a txt file named "Book1" to a folder called "Temp". Folder must excist or you will get an error.

Change folder and file name to suit your needs.

Alf