Hello. I've used the code below and it gives me an error sometimes. If I put the value at 1 it doesn't work, but if I put it at 3 it runs through. If I put it at 1 it says select method of range class failed. Isn't this supposed to select the 1st sheet if the value in h is 1?
Sub tst()
h = 3
Worksheets(h).Range("A1").Select
End Sub
Hi elmasguapo,
You can't select a cell apart from the active sheet (i.e. the sheet you're on). This is how you'd have to do it:
Note I've wrapped my code in the appropriate tags as you need to
Please Login or Register to view this content.
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
@Trebor. Thanks, I didn't know that. I thought that the worksheet(variable) would automatically reference the worksheet and select the range.
What would I do if I had multiple workbooks in the same statement? So, h= 3 (intWsIndex) and i = 2 (or intWsIndex 2)?
Also, what if you aren't selecting the range but just referencing it. Do you still need the with? I tested it and it doesn't look it.
Last edited by elmasguapo; 10-14-2015 at 06:30 PM.
This is some code that I'm trying to piece together but it's not working and I'm not sure why. It seems like it should work since it's not actively selecting the sheets but rather just referencing them.
Please Login or Register to view this content.
What are you trying to do? You may need to attach a workbook (desensitised) with before and after scenarios so I can try and provide a solution.
I think it's pretty straightforward. H and I evaluate to 1 and 2. On the next loop they evaluate to 4 and 5, then 7 and 8, etc. I'd like to use them as variables to reference sheets in the consolidate range function but it's not working. Thanks for your help.
Please Login or Register to view this content.
Not for me as I'm having trouble understanding your code.I think it's pretty straightforward.
No, h is 2 and i is 1 etcH and I evaluate to 1 and 2
This isn't referencing the a sheet by its position in the workbook but a tab called "Sheet(2)" (in the first loop). Is that correct?"Sheets(h)!R1C1:R3C3"
Yeah, sorry, I got the order of H/I switched. AH!!! I thought it was referencing the sheet order. How can I get it to order the 1st/2nd sheet from the left (as opposed to the sheet name)? Thanks!!
Is this what you're after:
Regards,Please Login or Register to view this content.
Robert
@ Trebor. Thank you!! Perfect!! A couple of questions: What's the difference between usings sheets/worksheets in this case? Why do I need to add the ".name"? And lastly, why do I need to place the !R1C1 i n""? Muchas gracias.
I have a question for you actually - why have you changed your name from ammartino44??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks