LinkBack URL
About LinkBacks
I need help to make the below code to be based on named ranges instead of the alphanumeric using offset
Cell "E36" in page "2013" is named "Start"
Cell "A1" in sheet "2014" is named "Target"
//E
Please Login or Register to view this content.
I need help to make the below code to be based on named ranges instead of the alphanumeric using offset
Cell "E36" in page "2013" is named "Start"
Cell "A1" in sheet "2014" is named "Target"
//EPlease Login or Register to view this content.
HI Emma,
I'm not that familiar with named ranges - so, see if the syntax is appropriate:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Are you looking for the syntax
or (across workbooks) perhaps this syntaxPlease Login or Register to view this content.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi Mike,
Is my syntax proper? She wants to use offset with her named ranges
Once you have Range("myNamedRange"), its a range object and .Resize or .Offset will work.
At this point, I think we are both waiting for the OP to explain what "based on named ranges" means to them.
@ Mike - It seems that offset and resize always operate on ranges
Yeah, my interpretation of the need was "I have a named range, how do I refer to it in VBA?".
So, what about my syntax
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks