About Us

RobcPettit[_2_]

Hi, Id like to know if its possible with vba to add number of rows to
a given range so I can then select those cells. If my range is "A3"
and I want to add 30 rows, so A3 + 30 = A3:A33. The number to be
added is not static and changes depending on previous results.
regards Robert

joel[_139_]

You need to use rows.count

Set Myrange = Range("A1:A10")
Set Myrange = Myrange.Resize(Myrange.Rows.Count + 30)

--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149542

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how copy formula that contains ranges so ranges do not overlap	Patty	Excel Worksheet Functions	1	November 20th 08 04:15 PM
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use...	christian_spaceman	Excel Programming	3	December 24th 07 01:15 PM
union of named ranges based only on the names of those ranges	sloth	Excel Programming	3	October 2nd 06 03:18 AM
Copy data in named ranges to a newer version of the same template to identical ranges	handstand	Excel Programming	0	August 21st 06 03:51 PM
named ranges - changing ranges with month selected	gr8guy	Excel Programming	2	May 28th 04 04:50 AM

Menu

About Us