change the range on autofill to use defined variables

**clemsoncooz** · 02-01-2012, 05:34 PM

If I have this code:

Please Login or Register  to view this content.

Why cant I change the range on:

Please Login or Register  to view this content.

To be using the variable from the search result? Like:

Please Login or Register  to view this content.

B/c this doesnt work.

**StephenR** · 02-01-2012, 05:58 PM

H117 is an address not a range value so you need

Please Login or Register  to view this content.

**clemsoncooz** · 02-02-2012, 10:34 AM

Perfect! Yep. That fixed it! Thank you!

One part of the code that I didnt show was something as simple as:

Please Login or Register  to view this content.

Which is just define a variable called "Design_rowsCount" as the value in a certain cell on sheet9. This value will change but its also a number (generally between 1 & 10).

So then - how do I change the ":H122" to be "Design_rowsCount" away from search_result.offset(2,0).address?

**OnErrorGoto0** · 02-02-2012, 10:39 AM

Please Login or Register  to view this content.

for example. You may need to add 1 to Design_rowsCount depending on what you mean by "away from".

**clemsoncooz** · 02-02-2012, 10:43 AM

Thanks to the both of you. You got it!

I very much appreciate you looking at that with me!

change the range on autofill to use defined variables

LinkBack

Thread Tools

Rate This Thread

Display

change the range on autofill to use defined variables

Re: change the range on autofill to use defined variables

Re: change the range on autofill to use defined variables

Re: change the range on autofill to use defined variables

Re: change the range on autofill to use defined variables

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions