Can anyone remind me why this doesn't work.
It will work if I separate them.
sheets("sheet1").range("A1").select
and sometimes it works if I do thissheets("sheet1").select range("A1").select
But I forget why the first version doesn't work.sheets("sheet1").range("A1").activate
Version 1 works fine for me (at least once I changed sheet1 to Sheet1 as my sheet has a capital letter at the start)
Sheets("Sheet1").Range("A1").Select
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Hmm. It definitely doesn't work for me, capitol letter or not, unless I am already on Sheet1.
Hi, Jiptastic,
why don´t you use
Ciao,Application.Goto Reference:=Sheets("Sheet1").Range("A1")
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Are you getting an error message?
What happens if you run
Sheets("Sheet1").Range("A1").Value = "111"
Hi, WasWodge,
if you´re not on the sheet and run your code RTF 1004 should show up - not with my sample though.
Ciao,
Holger
Hi, WasWodge, if you´re not on the sheet and run your code RTF 1004 should show up - not with my sample though.True. That's what comes of replying from your phone without testing. I was probably on the same sheet when I replied the other day. Apologies
P.S. could have done with an embarrassed smiley
Last edited by WasWodge; 05-09-2013 at 03:52 PM.
It gives run time error 1004. The code below runs fine. The application.Goto code does the job as well. I'm not sure what's easier, using the application code or just separating the lines of sheet and range.
Sheets("Sheet1").Range("A1").Value = "111"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks