find the first non blank cell in a row

[HarryKlein]

Hi,

I need to iterate throgh a range. Each row contains begins in different column.
Is there an easy way to find the first non-blank cell in the row without creating a loop for each row?
Thank you

[Keebellah]

Select the top row and press End PgDwn takes you to the last filled row offset 1 and you're there, but I think you want to do this with a macro?

Please Login or Register  to view this content.

[HarryKlein]

Yes, I need a macro, this is just the first step.

[Keebellah]

The first step is the code i added