Using a named cell in a macro - same workbook
Solved/Closed
marcia
-
Nov 23, 2009 at 09:17 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 24, 2009 at 05:32 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 24, 2009 at 05:32 AM
Related:
- Using a named cell in a macro - same workbook
- Spell number in excel without macro - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Run macro when cell value changes by formula ✓ - Excel Forum
- Run macro on opening workbook - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 23, 2009 at 08:27 PM
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
range(name of the cell in double quotes).(any method or property)
for e.g. the name is rv
range("rv").select
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 24, 2009 at 05:32 AM
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.
Nov 24, 2009 at 02:50 AM