I am trying to run this line of code:
If rCell.Value * 100 < Sheet2.Cells("A2").Value * 100 Then
and I get an error... "Type Mismatch"
Both rCell and Sheet2.Cells("A2") are defined as percent cells.
What is wrong???
Thank you
I am trying to run this line of code:
If rCell.Value * 100 < Sheet2.Cells("A2").Value * 100 Then
and I get an error... "Type Mismatch"
Both rCell and Sheet2.Cells("A2") are defined as percent cells.
What is wrong???
Thank you
Try:
Sheet2.Range("A2")
Mangesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks