mike637

asked on

# Excel VBA Find last column in range

Ugh!!

Hell Experts,

I need help to find the last used cell column number in a set range.

My range is "B4:H4". As long as there is something in one of those cells - that is my column number I need.

I have data in A4 & I4 so I can not use the typical examples I found on-line.

Once I find the column number - I can finish my code.

Any assistance would be great,

Thanks

Hell Experts,

I need help to find the last used cell column number in a set range.

My range is "B4:H4". As long as there is something in one of those cells - that is my column number I need.

I have data in A4 & I4 so I can not use the typical examples I found on-line.

Once I find the column number - I can finish my code.

Any assistance would be great,

Thanks

Will the range always be B4:H4?

ASKER

Yes it will.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thank you Andrew!

I was about to give up and go get a drink. :)

Also - thanks for taking this on a Sunday - you are awesome.

Michael

I was about to give up and go get a drink. :)

Also - thanks for taking this on a Sunday - you are awesome.

Michael