Using Offset As A Variable Gives Errors

**Genus Max** · 01-26-2020, 11:41 AM

Hi, Not sure why this doesnt work, trying to use offset as a variable - ValuesRangex = ValuesRange.Offset(i, 0).Address, everything else works fine.

Thanks again.

Please Login or Register  to view this content.

**Fluff13** · 01-26-2020, 11:45 AM

Maybe

Please Login or Register  to view this content.

**Genus Max** · 01-26-2020, 11:49 AM

That works great, but now I cant get MsgBox to display the range ValuesRangex ...

**Fluff13** · 01-26-2020, 11:54 AM

Add the .Address to it

**Genus Max** · 01-26-2020, 11:56 AM

Thanks again.

**Fluff13** · 01-26-2020, 11:59 AM

My pleasure

Using Offset As A Variable Gives Errors

LinkBack

Thread Tools

Rate This Thread

Display

Using Offset As A Variable Gives Errors

Re: Using Offset As A Variable Gives Errors

Re: Using Offset As A Variable Gives Errors

Re: Using Offset As A Variable Gives Errors

Re: Using Offset As A Variable Gives Errors

Re: Using Offset As A Variable Gives Errors

Thread Information

Users Browsing this Thread

Similar Threads

Offset with a variable

[SOLVED] Handling Errors from Formula result, stored in a variable.

[SOLVED] Vba code to check if there are formula errors and put them in a variable

Select offset variable offset cells

[SOLVED] Offset an IF Function that checks for mathematical errors...

Using Offset in VBA with a Variable

Offset with variable

Bookmarks

Bookmarks

Posting Permissions