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 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 <davebonall...@hotmail.com>
wrote:
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
Exit For
Next c
D = ActiveCell.Value
ActiveCell.Value = A
Range(B).Value = D
End Sub
It should be quicker than a dialogue box with 3 questions.
Regards - Dave.
Date: Tue, 20 Apr 2010 14:55:44 +0300
Subject: $$Excel-Macros$$ Urgent Help Required in a macro
From: chaudhry.zahid....@gmail.com
To: excel-macros@googlegroups.com
Hi Group,
I'm working in a huge excel sheet with thousands of entries. I am currently
looking for a macro, that when invoked (upon press of a key etc) would open a
dialogue box having three fields. The first field being Select Row, In which I
can write a row number Like 3, the second filed would contain "Replace item
from column", where I can write, for example G, and the third field containing
an other "Replace item from column" for example AA. In this case the VBA code
should select cells G3 and AA3. Than when I press enter or a button on the
excel sheet the contents of cell G3 should go to AA3 and contents of AA3 should
go to G3. The dialogue should not close after the cell contents have been
replaced, but should close upon clicking the cross because there would be
mutiple entries that need correction.
An urgent reply and help would be highly appriciated, I have very little time
to do tjis HUGE task of finding and replacing data in excel.
Thanks in advance and Regards,
ZAC.
--
----------------------------------------------------------------------------------
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 6,800 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
Find it on Domain.com.au Need a new place to live?
--
----------------------------------------------------------------------------------
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 6,800 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 6,800 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
_________________________________________________________________
Browse profiles for FREE! Meet local singles online.
http://clk.atdmt.com/NMN/go/150855801/direct/01/
--
----------------------------------------------------------------------------------
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 6,800 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
