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 DatRng

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 rajeshkainikk...@gmail.comwrote: 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

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 vikramahuj...@gmail.com wrote: Hi, Please advice the way by which we can view such macros and add in our workbooks. As this function is showing

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

Dear Vikram i am attached rupees-word.basmacro 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

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 gjmothi...@gmail.com 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

$$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

$$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

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 karankan...@gmail.com 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 koul.ash...@gmail.com wrote: see if it helps

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 vijayajith...@gmail.comwrote: hai Please see the attched exl file.. i need your help thanks --

$$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

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 robb@gmail.com rng =OFFSET(Foglio1!$A$1,,,50,50) regards r 2011/4/24 karan karankan...@gmail.com Hi Thanks for the formula. It does help, but while

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