Can't figure out loop error

**Ravenous** · 02-28-2023, 10:42 PM

Hi All,
I am getting a Object variable or With Block variable not set error on the below code. The line of the error begins with RR =.
Any ideas on what I am missing here? Also if someone could check over the remainder of the code after that line to make sure there are no errors as well that would be amazingly helpful. Many thanks

Please Login or Register  to view this content.

**protonLeah** · 02-28-2023, 11:02 PM

Set RR = ES.Cells(i, "c").Resize(COLUMNSIZE:=50)

**protonLeah** · 02-28-2023, 11:09 PM

Max Excel rows is 1,048,576
max integer is 32,767, so i should have been Dim'd as Long vs Integer

**Ravenous** · 02-28-2023, 11:21 PM

Thanks! I knew it was something simple. Althoug I am now getting a Type mismatch error on the below line. Can you explain where the issue is here?

Please Login or Register  to view this content.

**protonLeah** · 03-01-2023, 12:02 AM

I have no way to test it, but:
'Employee Skills'!" & RR
looks like it should be:
'Employee Skills'!" & RR.Address ?

**Ravenous** · 03-01-2023, 12:07 AM

Thanks again. I have delcared the address for RR on the below line. Is this how a Range variable works?

Please Login or Register  to view this content.

**Ravenous** · 03-01-2023, 12:19 AM

Oh wait I get it now, you mean literally add the .address. It works now but it is appearing with an @ at the start and not giving the full array result, only the first result.
Any ideas on how to combat this?