Posted to microsoft.public.excel.programming

Mark Stephens[_3_] Mark Stephens[_3_] is offline

external usenet poster

Posts: 15

how to count the number of occupied columns in a sheet?

I know how to count rows:

lgLastRow = Workbooks(2).Sheets(pbFundSheetNo).Cells(Rows.Coun t,
"A").End(xlUp).Row

Can the same code be adapted to count the number of used columns?

Thanks, Mark

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
Count the number of columns on row that are not empty within a ran	Mathew	Excel Discussion (Misc queries)	3	March 30th 10 07:34 PM
count number of duplicates between 2 columns	SteveC	Excel Discussion (Misc queries)	8	February 2nd 09 07:07 PM
Number of rows/columns occupied	Will	Excel Worksheet Functions	4	January 11th 09 10:27 PM
Pivot Table - How do I count number of columns?	vicky	Excel Discussion (Misc queries)	5	August 8th 06 01:26 PM
Excel, how to count every 4th cell in column to see if occupied?	Ashley	Excel Worksheet Functions	4	July 19th 06 07:27 PM

All times are GMT +1. The time now is 06:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us