July 8, 2006 at 7:22 PM #1 i have this: Code Sheets("Sheet2").Application.Goto Reference:="R1C1" it is supposed to go to cell A1 in Sheet2.but it doesn't go to sheet 2 ???
July 8, 2006 at 7:26 PM #2 Re: vba goto specific celltried this Code Application.Goto Reference:="Sheet2!R1C1" i thought it worked, but it doesn't always.i want to include in my beforeclose command that the cell should be there so next time it's opened (with macro on or off) it will be in a1 of sheet2.
July 8, 2006 at 7:47 PM #3 Re: vba goto specific cellTry Code Sheets("Shee2").Select Cells(1, 1).Select
July 8, 2006 at 8:04 PM #4 Re: vba goto specific cellhi roy,is there a line command, something using application.goto ?i see what you are saying, it is close to what i get when i record a macro.
July 10, 2006 at 9:28 AM #5 Re: vba goto specific cellApplication.GoTo takes a range Object as its argument, not a String. E.g Code Application.GoTo Sheet2.Range("A1"),True