Hi, I was wondering if someone could help me with this.
I'm looking for a cell with a specific background color. I need to put the range of the found cell into a variable so i can refer to it later, but i can't.
I tried different things but the closest I get is a Type Mismatch error and don't understand why. I declared the variable as Range and I'm setting it to an Address. In my mind it should work, but it doesn't.
Check the part of the code where [MsgBox var.Address] is. The box shows a range (like $E$4), but when i replace the MsgBox line with: [Set var = var.address] then i get the error. What am i doing wrong?
Bookmarks