Hello,
In my cell i have string (e.g. 111 Weekly) in column C, what i am trying to do is copy the contents of column C into COlumn D and then remove the first four characters of the cell, i have the following formula
=right(A1,LEN(A1)-4)
how can i put this into VBA to be part of a loop that i am creating?
Many Thanks
Bookmarks