Set Dynamic Range based on values

**cap09** · 07-20-2009, 10:43 PM

Hi all,

I would like to create a dynamic range based on a cell value. However, the cell reference may vary because the numbers of entries in the workbook can vary.

In addition to that, after the first range (eg. A1:A10), I would like to create a second range after the first (eg. A11:A20).

Please see attached sheet for data example.

Thanks in advance.

alex

**rylo** · 07-20-2009, 11:47 PM

Hi

What sort of "dynamic range"? Do you want a series of defined names? Or do you want ranges to be used in a loop in code?

Please give more detail on exactly what you want to create.

rylo

**cap09** · 07-20-2009, 11:50 PM

Hi all,

Got the answer from another forum

here is the code

Please Login or Register  to view this content.

thanks for viewing and trying to help.

mods please close this thread

Set Dynamic Range based on values

LinkBack

Thread Tools

Rate This Thread

Display

Set Dynamic Range based on values

Re: Set Dynamic Range based on values

Re: Set Dynamic Range based on values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions