dynamic cell reference

deuxo · May 10th, 2002, 10:38 AM

I am trying to determine how to create a named cell range when I know the row number and the column number. For example, I find the last row in a spread sheet, assume LastRow=20, I then want to create a named cell range, assume My Cell, so that MyCell=A20. I then want to select this range,
Range("MyCell").Select.
To complicate this, LastRow needs to be dynamic, so that I need to have MyCell=ALastRow . I am not sure how to create a named cell renage where the row number can vary. Any help is appreciated.Thanks.

Tom Schreiner · May 10th, 2002, 04:31 PM

I'm not sure if this will help you or not?
Look at the code carfully before running it. It will delete all of your named ranges.



http://www.mrexcel.com/board/viewtop...c=7082&forum=2

Tom

May 10th, 2002, 04:31 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	I'm not sure if this will help you or not? Look at the code carfully before running it. It will delete all of your named ranges. http://www.mrexcel.com/board/viewtop...c=7082&forum=2 Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 10:38 AM	#1
deuxo New Member Join Date: Mar 2002 Posts: 13	I am trying to determine how to create a named cell range when I know the row number and the column number. For example, I find the last row in a spread sheet, assume LastRow=20, I then want to create a named cell range, assume My Cell, so that MyCell=A20. I then want to select this range, Range("MyCell").Select. To complicate this, LastRow needs to be dynamic, so that I need to have MyCell=ALastRow . I am not sure how to create a named cell renage where the row number can vary. Any help is appreciated.Thanks.