value to range

  • Thread starter Thread starter Aksel Børve
  • Start date Start date
A

Aksel Børve

is it possible to make a macro that use the value in a cell (eg.1002), and
make a Range with same number (1002 cells) of cell's that's diplay in the
one cell.
 
If the number of cells is in cell A1, use code like the
following:

Dim Rng As Range
Set Rng = Range("B1").Resize(Range("A1").Value,1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

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

VBA set thick borders around non empty cells in range 0
value to a range 2
Copy and Paste + erasing date 1
MAX AVERAGE MIN with additional criteria, ignoring blank cells 6
Writing Single Dimension Array to Active Sheet 2
Modify Vlookup 5
Excel Macro to automatically go to the right of the last colored cell 0
link cells in master worksheet to other cells in other worksheets 2

Back
Top