Replies

Hi Legare,

Again thanks for all of your help. I’m honestly not trying to be the problem that won’t go away. I think I’m almost there. A remaining problem/issue is that I can see the named ranges when I click on Insert/Name/Define, but they do not show up in the worksheet “NAme Box” as my manually created ranges did (see attached). Also referencing them from the embbedded objects in Word also doesn’t work (link error). What’s baffling me is that my manually created named ranges worked perfectly, but these don’t – even though the named range seems to be identical (start/end cells).

What am I missing?

Thanks,

Hi John,

Thanks for the feedback. I did as you suggested and it worked as you indicated.

Thanks again,

Thanks rory,

Trying to get Legare’s macro to work. I appreciate your feedback.

Regards,

Hi Legare,

First, I appreciate your generosity with your time and expertise – thank you again! I followed your detailed instructions carefully (three times) and had no luck with the macro. As far as I could tell, no range names were created in the spreadsheet. I’ve attached a VBA screen shot just to verify that I stored the macro correctly. It appeared in the Macros menu as you indicated it would . . . it just didn’t seem to do anything.

I realize I’m really taking advantage, but any additional help is greatly appreciated.

Regards,

Hi Rory,

Thanks for your response. Every row has to be named because they’re embedded as objects in word documents as absolute links. I need to make them all relative so that I can sort and delete rows from the spreadsheet without “breaking” the Word documents. Thanks again!

Hi Legare,

Thanks for this! I cannot get it to work and I’m much too inexperienced to quickly figure out why. I saved your macro into the worksheet and attempted to run it, but with no luck. I’ve attached a screen shot of the beginning of the spreasheet so that you can see what I’m working with. If you can provide any additional help, it’s greatly appreciated.

Thanks!

Hi Hans,

Thanks very much for your help. I’m now working on a macro (that I will also be asking for help on) to name all of the ranges in my spreadsheet. There are 1300+ rows, so a macro is a neccessary! I’m posting a question about how to modify a simple macro I’ve created soon. If you have a moment, I would greatly appreciate any insights you may have on that issue as well.

Thanks again,
Bill

Hi Steve,

Thanks for the good input – it’s appreciated! For my purposes, I’m keeping it as simple as possible, so the first method works better for me (for now). My next post question will refer to how to make a simple macro use relative references so I can automate the range naming process for my worksheet which has around 1300 rows.

Thanks again,
Bill

I was afraid of that! I’ll give that a try. Thanks for your help!

Regards,

I was afraid of that! I’ll give that a try. Thanks for your help!

Regards,