View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mr Cockles[_2_] Mr Cockles[_2_] is offline
external usenet poster
 
Posts: 3
Default Rollover Define Name

Hi ,

I would like to add one, to the column of an original defined name, so as to
move the defined cell along one space, using the ActiveWorkbook.Names.Add
function. I'm trying to create a variable to get the original cell reference
and then just add one to the column reference, using the function above. How
do I do this?

Kind regards and thanks in advance

Jeff