Posted to microsoft.public.excel.programming

Sanj

external usenet poster

Posts: 25

Referencing a Range

I have refered to a range, where I do not know where the end is by
Set rng = Worksheets().Range(Cells(a,b), Cells(c,d)). This tends to be
flaky and I don't want to use the "A1" notation.

Any suggestions?

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
Referencing a named range based upon Range name entry in cell	Barb Reinhardt	Excel Worksheet Functions	14	June 20th 07 07:19 PM
Referencing a Range	Sanj	Excel Programming	0	June 16th 05 11:13 PM
range referencing	lakey13[_6_]	Excel Programming	0	November 9th 04 04:30 PM
range referencing	lakey13[_4_]	Excel Programming	0	November 9th 04 03:38 PM
range referencing	lakey13[_3_]	Excel Programming	1	November 5th 04 10:46 PM

All times are GMT +1. The time now is 09:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us