Naming a Range of Cells where Range is Variable.

You've got strcell and encell in quotes.

Oh, and encell should be EndCell

Hi Andrew.

Thanks for that. Just removed the quotes - I get a 'Runtime Error 1004 - The formula typed contains an error...'

Any Ideas?

Cheers,
Mark

Current Code for that Line:

Please Login or Register  to view this content.

Still throws up same error using StartCell & EndCell

Cheers

Should it be strcell rather than StartCell?

Theoretically encell=EndCell & strcell=StartCell. I'v etried the combination you suggest but still no luck :-(

Try changing RefersToR1C1 to just RefersTo ... you're not providing the range in an R1C1 format.

PS StartCell and strcell are not the same thing ... strcell is a string variable, but StartCell is an object, they're treated very differently.

Bingo - Got it working.

Please Login or Register  to view this content.

Used strcell & encell as these I believe (?) refer to the reference of the cell as opposed to the value in the cell (StartCell & EndCell). Removed the R1C1 as you suggested and its working as desired.

Thanks very much for your help!

Mark

strcell and encell hold a string which is the cell's address, e.g. "B2", "D73"

StartCell and EndCell are actually cell objects, so StartCell.Address will be the same as strcell, but you could also ask for StartCell.Row or StartCell.Formula, etc.