Posted to microsoft.public.excel.programming

Jamie[_11_] Jamie[_11_] is offline

external usenet poster

Posts: 2

Defining Dynamic Range

I have a spreadsheet that may change in size daily. How can I refer to the
range in VBA? CurrentRegion doesn't work as there may be empty rows or
columns in the range I want to select.

Looking for something that would give me (A1:"bottom right cell")

Thanks for any ideas.

Jamie

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
help defining dynamic range	joecrabtree	Charts and Charting in Excel	0	December 6th 06 03:33 PM
Defining Dynamic Ranges in Macro	Prashant Garg	Excel Programming	2	December 17th 04 01:47 AM
Defining a Range	Kaval	Excel Programming	2	September 5th 04 11:53 PM
Defining range	Edgar[_3_]	Excel Programming	2	February 17th 04 02:24 PM
Defining a range	Matt	Excel Programming	3	January 23rd 04 03:21 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us