defining location in VBA

[homegrownandy]

wb.ActiveSheet.Range("C4").Value

I don't want this to copy from the active sheet. I want it to copy from a sheet named "secondsheet" for the purpose of testing.

However, when I change this, my macro will open the second sheet but then it will stop rather than complete the rest of the code.

I'm confused as to why this is and would appreciate help.

Thanks! andy.

wb.secondsheet.Range("C4").Value <--- this is what I changed it to .

[humdingaling]

Please Login or Register  to view this content.

insert what the secondsheet is actually called

otherwise you can use
which will give the sheet next (to the right) to Activesheet

Please Login or Register  to view this content.

this will give to the left

Please Login or Register  to view this content.

however...if either left or right is the last sheet of the workbook...it will give an error

[homegrownandy]

Second sheet is named second sheet. but it can be called test sheet to save confusion.

The sheet in question doesn't actually exist yet I'm just testing to try and get this to work.

BUT, although it opens the correct sheet. the macro stalls on the first workbook on that sheet and does not carry out the rest of the tasks.

[homegrownandy]

Thanks mate, I've used your format and all is good!

[humdingaling]

not a problem

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.