Setting a variable range with a variable sheet name. Hmm?

[starcraftbud]

Hi,

I struggle with some of the rules required to declare variables in VBA code. I've done things like this in the past, but its not working today and I was hoping someone could easily see the issue. The NewFoundRange I'm trying to declare doesn't seem to work. And I do not get errors, but the CycleRange values are not populating the NewFoundRange values at the lower part of the code.

Please Login or Register  to view this content.

Any ideas? Do I need to set NewFundRange differently? I have not used the DIM function to set them to anything. I use Excel 2010. Thank you for taking a look at this thread.

[AB33]

What is " mark in

Please Login or Register  to view this content.

?

[starcraftbud]

I'm not completely sure I understand the question, but thanks for the response and I'll try to answer as best I can. That is definitely the line of code where I think there is an issue. I'm not sure if I've used the " correctly. I just use the " and the & symbol to refer to declared objects. Its what I normally do, but it could be wrong in this instance.

[AB33]

If it is a sheet name, you should use the same format as the one you have:

Please Login or Register  to view this content.

Should be sheets("sheetname")

sheetname is string. A string should be in " "
The sheetname should be in quotation mark and should not be any space. Names are also case sensitive
The easiest way to avoid any error is to copy the sheet name from the sheet itself and paste it in

Please Login or Register  to view this content.

That is replace "" & CycleRange & ""

[starcraftbud]

Thanks for the feedback guys. I was able to figure it out. I feel quite foolish, it was just a typo in my code.