Refencing Worksheets Issues

[shane0016]

I have little to no experience in VBA and I am struggling with referencing a worksheet within my code.

Basically what I am trying to do is look at the Raw Data sheet for a certain date and a range of values and then add the minutes associated with these values to another sheet. I am 99% sure my issues are with the referencing of the worksheets but I have done some googling and am a bit stuck.

Cheers

Please Login or Register  to view this content.

[Norie]

The worksheet references look fine here,

Please Login or Register  to view this content.

however you don't have any worksheet references here.

Please Login or Register  to view this content.

Without worksheet references here both instances of Cells will refer to the sheet that is active when the code runs.

By the way, where does the 'x' in the code come from?

[shane0016]

Woops I forgot to change something over when I edited it.

I'm getting Run-time error 9 Subscript out of range now.

Cheers for the help

Please Login or Register  to view this content.

[maym]

do you have data in these cells? Works ok for me.

[Norie]

That error suggests you don't have sheets named exactly 'Aug 17' and 'Raw Data' in the active workbook.

Check the sheet names again and look for things like trailing/leading spaces/typos.

[scottiex]

Or a sheet named "Raw".
My guess is either "raw" should be "raw data" or "raw data" should be "raw"

Please Login or Register  to view this content.

[shane0016]

Or a sheet named "Raw".
My guess is either "raw" should be "raw data" or "raw data" should be "raw"

Please Login or Register  to view this content.

Yeah thank you, this was the issue.

Cheers everyone