Moving to another cell
 

I am setting this spreadsheet up for our operators I need something tha
takes no thought from there sid

--
mporter50
-----------------------------------------------------------------------
mporter501's Profile: http://www.excelforum.com/member.php...nfo&userid=767
View this thread: http://www.excelforum.com/showthread.php?threadid=26617

Moving to another cell
 

Only first approach:
Range("A1:A6,B6,C7,D8").Select
Range("A1").Activate
ActiveWorkbook.Names.Add Name:="test", RefersToR1C1:= _

"=Sheet1!R1C1,Sheet1!R1C1,Sheet1!R2C1,Sheet1!R3C1, Sheet1!R4C1,Sheet1!R5C1,Sh
eet1!R6C1,Sheet1!R6C2,Sheet1!R7C3,Sheet1!R8C4"
Application.Goto Reference:="test"
Jorge
"mporter501" escreveu na mensagem
...

I am setting this spreadsheet up for our operators I need something that
takes no thought from there side


--
mporter501
------------------------------------------------------------------------
mporter501's Profile:
http://www.excelforum.com/member.php...fo&userid=7677
View this thread: http://www.excelforum.com/showthread...hreadid=266176