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

2010-04-21 Thread Dave Bonallack
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

2010-04-21 Thread Chaudhry Zahid Ali
or > 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 >

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

2010-04-20 Thread Dave Bonallack
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 macr

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

2010-04-20 Thread Chaudhry Zahid Ali
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 c