Basic Macro (Jump to Cell) erroring out

kethyar


Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

hi,

I had the same frustration as you for quite some time b/c I've always read that removing the individual selects & minimising the number of dots often results in faster code so I had done the same as you & I couldn't figure out why it wouldn't work until I found out about the "Goto" Method. If you want to remove the need for a 2 step process, here's a brief quote from the Help files...

Excel 2003 VBE Help files:
Goto Method
Selects any range or Visual Basic procedure in any workbook, and activates that workbook if it’s not already active.
expression.Goto(Reference, Scroll)
expression Required. An expression that returns an Application object.

Please Login or Register  to view this content.

I suggest looking the Goto Method up & reading the rest of the Help Notes which explains why your single line doesn't seem to work.

I also suggest changing your shortcut key from [ctrl + f] so that it is not the same as the default shortcut for Find in Excel (& a lot of the other app's in the Office suite) even if it is just changed to [ctrl + shift + f]. This will prevent any confusion if someone uses your computer or if you are distributing the file containing the macro.

hth
Rob