I'm a VBA newbie so i'm cobbling together pieces of code I've picked up online. I have the below which i think is close but rather than 'my text' i would like to repeat whatever is in the adjacent cell in column A. However, if there is already a value present in cell B, then don't do anything.
Help most appreciated.
Please Login or Register to view this content.
If cell.Offset(0, 1).Value = "" Then cell.Offset(0, 1).Value = Cell.Value
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Never got back to you AlphaFrog. Apologies. This is perfect - Thank you.
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks