Error 2023 in Range
-
Hi Friends, I am getting an error 2023 in range variable. Set rFoundCell_Value = Range(rFoundCell.Address).Offset(0, 1) in above rFOundCell is having range address as "A1" As wanted to fetch the value of the next col to A1 i am using the above line. I am not sure about this error. Please Help. Regards, Priya.
-
Hi Friends, I am getting an error 2023 in range variable. Set rFoundCell_Value = Range(rFoundCell.Address).Offset(0, 1) in above rFOundCell is having range address as "A1" As wanted to fetch the value of the next col to A1 i am using the above line. I am not sure about this error. Please Help. Regards, Priya.
What you are trying to do is set the rFoundCell_Value to an range object, i think that is why you get the error. have you tried,
rFoundCell_Value = rFoundCell.offset(0,1).valueLook at the code i provided to a similiar question earlier, it uses values, ranges, offsets http://www.codeproject.com/Messages/3536297/Re-Remove-whitespace-in-front-of-String-element-of.aspx[^]Dave Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com -
What you are trying to do is set the rFoundCell_Value to an range object, i think that is why you get the error. have you tried,
rFoundCell_Value = rFoundCell.offset(0,1).valueLook at the code i provided to a similiar question earlier, it uses values, ranges, offsets http://www.codeproject.com/Messages/3536297/Re-Remove-whitespace-in-front-of-String-element-of.aspx[^]Dave Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com