Posted to microsoft.public.excel.programming

Steph[_3_] Steph[_3_] is offline

external usenet poster

Posts: 312

Range as variable

Hi. I have a variable defined as below:
var3 = Cells(ActiveCell.Row, "D").Value

How can I convert var3 to be (in laymans terms) ActiveCell.Row, "D" through
BB xlleft

So if active row is 3, var 3 might be D3:G3, if G was the last data point
and H and to the right was blank.

Thanks!

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
Variable range in VB	famdamly	Excel Discussion (Misc queries)	2	January 22nd 06 02:29 PM
setting a range variable equal to the value of a string variable	Pilgrim	Excel Programming	2	July 1st 04 11:32 PM
variable range: l just can't get there!	ste mac	Excel Programming	2	October 27th 03 06:43 PM
Variable Range	Martin[_9_]	Excel Programming	1	October 12th 03 05:09 PM
Problem trying to us a range variable as an array variable	TBA[_2_]	Excel Programming	4	September 27th 03 02:56 PM

All times are GMT +1. The time now is 07:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us