Can anyone remind me why this doesn't work.
It will work if I separate them.
Please Login or Register to view this content.
and sometimes it works if I do thisPlease Login or Register to view this content.
But I forget why the first version doesn't work.Please Login or Register to view this content.
Version 1 works fine for me (at least once I changed sheet1 to Sheet1 as my sheet has a capital letter at the start)
Please Login or Register to view this content.
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,Please Login or Register to view this content.
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
Please Login or Register to view this content.
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
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.
Please Login or Register to view this content.
Please Login or Register to view this content.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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks