Nested Relative references in VBA - Errors for what should be easy

**mangoose736** · 02-08-2016, 02:03 PM

I am trying to get this to work:

Please Login or Register  to view this content.

but get a Run-time error '1004': Application-defined or object-defined error

I do not understand as the relative concatenate works, and the vlookup with static references work, but when combining them I get this error...

Concatenate with relative references that works:

Please Login or Register  to view this content.

vlookup with static references that works:

Please Login or Register  to view this content.

**shg** · 02-08-2016, 02:16 PM

You should use the Formula property or the FormulaR1C1 property, and then use a consistent reference style, not a combination of R1C1 and A1 references.

**Norie** · 02-08-2016, 02:21 PM

Try this.

Please Login or Register  to view this content.

**mangoose736** · 02-08-2016, 02:26 PM

Thank you guys, that worked...consistency (i should have known).

Nested Relative references in VBA - Errors for what should be easy

LinkBack

Thread Tools

Rate This Thread

Display

Nested Relative references in VBA - Errors for what should be easy

Re: Nested Relative references in VBA - Errors for what should be easy

Re: Nested Relative references in VBA - Errors for what should be easy

Re: Nested Relative references in VBA - Errors for what should be easy

Thread Information

Users Browsing this Thread

Similar Threads

How to for converting absolute references to relative references in formulas

Relative References?

Excel 2007 : Relative References

Relative references

Relative references

Relative references

[SOLVED] Relative references

[SOLVED] Should Be Easy - Relative Macros

Bookmarks

Bookmarks

Posting Permissions