Re: $$Excel-Macros$$ macro to add fill color to a column of selected range

That's excellent Dave. Exactly what I was looking for. Thanks!! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

Re: $$Excel-Macros$$ How to Separate Text and Nos in a sentence ?

hi karan unfortunately with very small numbers is small rounding errors. I attach a sample file regards r 2011/4/25 roberto mensa > rng =OFFSET(Foglio1!$A$1,,,50,50) > > regards > r > > > > 2011/4/24 karan > >> Hi >> >> Thanks for the formula. It does help, but while trying it on a new >> shee

$$Excel-Macros$$ Multiple file Formatting

Dear Gurus, I have created the attached macro for formatting of 50 to 60 files everyday which are receive from system. But to run this macro i need to open and then run. It taking too much time. Please can you advise to prepare the macro which will give facility do similar formatting of all fi

Re: $$Excel-Macros$$ help

see if it helps name:- =VLOOKUP(A25,A4:$C$8,2,0) lecture =VLOOKUP(VLOOKUP(A25,$A$3:$C$8,3,0),$A$13:$C$16,3,0) On Mon, Apr 25, 2011 at 6:36 PM, vijayajith VA wrote: > hai > > > Please see the attched exl file.. > > i need your help > > thanks > > -- > > -

Re: $$Excel-Macros$$ How to Separate Text and Nos in a sentence ?

rng =OFFSET(Foglio1!$A$1,,,50,50) regards r 2011/4/24 karan > Hi > > Thanks for the formula. It does help, but while trying it on a new > sheet its not working it gives an error #NAME? > > On Apr 19, 9:07 pm, ashish koul wrote: > > see if it helps > > > > > > > > > > > > On Tue, Apr 19, 2011

$$Excel-Macros$$ help

hai Please see the attched exl file.. i need your help thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

$$Excel-Macros$$ Need Help!!!!!!!!!!!!!!!

Hi, I have Two Different Sheets one is mail sheet and another is general sheet. when i open the both sheets and select the arrange all then tilled, then booth sheets open side by side now my Question is, is it possible when i select one name in main sheet it automatically highlight in the Second

Re: $$Excel-Macros$$ Excel spell out word from number

Dear Mothilal.j, Thanks for the sollution Badal Singh On Sat, Apr 23, 2011 at 12:02 PM, jmothilal wrote: > Dear Friend > > > here with i am attached fle macro file u add this. > > Thanks with > > Mothilal.j > Vellore-2 > > > On Wed, Apr 20, 2011 at 7:33 PM, Tony O wrote: > >> I have an Excel

Re: $$Excel-Macros$$ Excel spell out word from number

Dear Vikram i am attached "rupees-word.bas " macro file with this mail , do the following steps 1. open the excel file 2. select tools - macros - visual basic editor - file - import - select "rupees-words.bas" close it 3. save the excel file 4. again open note : Select Macro Secu

Re: $$Excel-Macros$$ Excel spell out word from number

press alt+ f11 to view or write a new macro http://www.techbookreport.com/tutorials/excel_vba1.html On Sat, Apr 23, 2011 at 6:09 PM, vikram wrote: > Hi, > > > > Please advice the way by which we can view such macros and add in our > workbooks. > > > > As this function is showing in sheet atta

Re: $$Excel-Macros$$ Show full screen for a particular workbook only.

check the attachment see if it helps On Sun, Apr 24, 2011 at 8:33 PM, Rajesh K R wrote: > Hi Paul, > Thanks for the answer I checked the same idea before I sent the > message, I give the fullscreen code when the work book open, but when > I give the code for display screen normal when work book

Re: $$Excel-Macros$$ A VBA Challenge.. (Arrays)

when you say it is a challenge; then you have to have your own good answer. Sub Time_Test_Array2() Dim DatRng As Range, LastRow As Long Dim r As Long, i As Long Application.ScreenUpdating = False Range("E:E, K1:K3").Clear Range("K1") = Timer LastRow = Cells(Rows.Count, 1).End(xlUp).Row Set Dat