Using a named cell in a macro - same workbook

Solved/Closed
marcia - Nov 23, 2009 at 09:17 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 24, 2009 at 05:32 AM
Hello,

seems simple but I'm just not getting it....I'm using excel 2003 and am trying to use a named cell on one sheet in a macro on a different sheet (which will be the active sheet) - any clues?

2 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Nov 23, 2009 at 08:27 PM
use

range(name of the cell in double quotes).(any method or property)
for e.g. the name is rv
range("rv").select
0
thank you -it worked perfectly. Would you know the other bit - is it best to use a select case to run through all of the headings in row 1 (rows with data) or an if then statement.
0
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Nov 24, 2009 at 05:32 AM
bot are same. I am personally more comfortable with if then rather than select. It is only personal prejudice. select case is elegant see the code.
0