Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2

Finding last non-empty column in row...

This code works fine:
MsgBox Cells(Rows.Count, "A").End(xlUp).Row

But this does not:
MsgBox Cells(Columns.Count, "2").End(xlLeft).Column

Any ideas how it should be changed to work?

Thanks!
Mika.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Finding First Empty Cell in a Column	TomHull	Excel Discussion (Misc queries)	5	November 9th 09 01:19 AM
Finding First Empty Cell in a Column	TomHull	Excel Discussion (Misc queries)	0	November 9th 09 12:21 AM
Dynamically finding the last empty row	Mike Potocki	Excel Programming	3	October 17th 03 04:34 PM
Finding Empty Rows	Tom Ogilvy	Excel Programming	0	July 16th 03 04:54 PM
Finding Empty Rows	Don Guillett[_4_]	Excel Programming	0	July 16th 03 04:50 PM

All times are GMT +1. The time now is 12:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us