RE: $$Excel-Macros$$ Urgent Help Required in a macro

You're welcome. Regards - Dave. Date: Wed, 21 Apr 2010 11:45:50 +0300 Subject: Re: $$Excel-Macros$$ Urgent Help Required in a macro From: chaudhry.zahid@gmail.com To: excel-macros@googlegroups.com Thanks a bundle Dave. This has expedited my work even more. :-) (P.S) Can anyone

Re: $$Excel-Macros$$ Urgent Help Required in a macro

Thanks a bundle Dave. This has expedited my work even more. :-) (P.S) Can anyone refer me to a good course from where I can learn to write macros... On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack wrote: > Hi Zac, > Can I suggest a simpler approach? > Using the Ctrl key, select the 2 cel

RE: $$Excel-Macros$$ Urgent Help Required in a macro

Hi Zac, Can I suggest a simpler approach? Using the Ctrl key, select the 2 cells you want to swap, then use a shortcut key to run this code: Sub swap() If Selection.Count <> 2 Then Exit Sub A = ActiveCell.Value B = ActiveCell.Address For Each c In Selection c.Select