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, 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 Loop Until IsEmpty(ActiveCell) End Sub To run this code. click on the first cell where you want to start the changes (in my example it is cell B2) and then click on the button named village. Pl let me know if u need any further help on this. Cheers!!, Andy On Tue, Jul 6, 2010 at 8:11 PM, Alexander Cargill <zanderman1...@googlemail.com> wrote: Hi All I was wondering if you could help. I have a column of data which is Column B within a sheet that I wish to alter, the data has the following format : XXX|XXX and I wish to change the contents of the cells in the column from XXX|XXX to [village]XXX|XXX[/village] using a single button. So essentially I want to add the text [village] before the co-ords and the text [/village] after the co-ords in each cell in column B can anyone help?? Thanks very much Alex Ps I can supply the sheet if needed J -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
