Posted to microsoft.public.excel.programming

filo666

external usenet poster

Posts: 265

Determining number of columns of 2 different ranges

I'm selecting two separate areas of my worksheet using Ctrl-Click(drag);
a1:a4 and c1:c4

I would like to know how to get the column number 1 for colum "A" and 3 for
colum "C".
pd, I'm not always using the same areas (it could be d1:d56 and g1:g7; and
in this case I want 4 and 7 respectivly).

TIA

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
Determining volume/number.	Jim Smith	Excel Programming	7	February 20th 06 01:26 PM
need help determining a row number	Gary Keramidas	Excel Programming	7	November 13th 05 03:54 AM
Determining if two ranges overlap	Marky[_2_]	Excel Programming	4	February 18th 04 09:54 AM
Determining Row Number	Wes Jester	Excel Programming	2	August 26th 03 09:20 PM
Determining Active Row Number	Don Guillett[_4_]	Excel Programming	0	August 20th 03 11:04 PM

All times are GMT +1. The time now is 03:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us