Finding first filled column

[nalfin]

Hi,

Trying to write a macro to find the range on a sheet where userdata are presented.

My starting point here is to find the first and last used column, and row, and by that information create my customized range.

However, I cant find the correct command to set the first used column. I'm using the following code which works in Excel 2003, but in Excel 2007 it only returns a "0".

Please Login or Register  to view this content.

My code to find the last column works perfect in both 2003 and 2007 though.

Please Login or Register  to view this content.

How should I do to find the first column in my sheets which contains any data?

[Leith Ross]

Hello nalfin,

I am not sure this will fix the problem because I can't test it on Excel 2007. It does work correctly on Excel 2003. This constrains the search to only the UsedRange rather than the entire worksheet. Give it try.

Please Login or Register  to view this content.