add ranges

R

RobcPettit

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
 
J

joel

You need to use rows.count

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort a range of strings using VBA code? 5
Eliminate blank row at top of Text Box entries 3
[Q] For, Next - How to Speed Up 6
How can i not copy the headers? 3
Development combinations with exclusion of columns 0
Development combinations with exclusion of columns 0
Code to add comments to selected cells within a selected range 30
Looping 3

Top