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
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