RE: $$Excel-Macros$$ How to alter the contents of a row in a sheet

2010-07-07 Thread Alexander Cargill
Absaloutly perfect mate J thanks so much From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Aindril De Sent: 07 July 2010 02:25 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to alter the contents of a row in a sheet Hi Alex

Re: $$Excel-Macros$$ How to alter the contents of a row in a sheet

2010-07-06 Thread Aindril De
Hi Alex, Please find attached the solution. I have used the following code inside a module Sub village() ' This loop runs until there is nothing in the last cell ' Aindril De (Andy) Do ActiveCell.Value = "[village]" & ActiveCell.Value & "[/village]" ActiveCell.Offset(1, 0).Select