date:20110425

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

2011-04-25 Thread STDEV(i)

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 = Range("A1:A" & LastRow)

For i = 1 To DatRng.Rows.Count
If DatRng(i, 1) Mod 2 = 0 Then
   Cells(i, 5) = "Event Number"
Else
   Cells(i, 5) = "Odd Number"
End If
Next i

Range("K2") = Timer
Range("K3") = Timer - Range("K1")

End Sub



On Sun, Apr 24, 2011 at 9:13 PM, Deepak Pal Singh  wrote:

> Hi Guy's
>
> Need your help in this code.. in the following code...
>
>
>
> Sub Time_Test_Array2()
>
> Range("K1") = Now()
>
> Application.ScreenUpdating = False
>
> Range("E:E").Clear
>
> LastRow = 0
>
> LastRow = Range("A100").End(xlUp).Row
>
> iVal = Range("A1:A" & LastRow).Value
>
> ReDim strArray(1 To UBound(iVal))
>
> For i = LBound(iVal) To UBound(iVal)
>
> If iVal(i, 1) Mod 2 = 0 Then
>
> strArray(i) = "Even Number"
>
> Else: strArray(i) = "Odd Number"
>
> End If
>
> Next i
>
> Range(Cells(LBound(strArray), 5), Cells(UBound(strArray), 5)).Value =
> strArray
>
> 'Range(Cells(LBound(iVal), 5), Cells(UBound(iVal), 5)) = iVal
>
> ActiveSheet.Range("K2") = Now()
>
> End Sub
>
>
>
> Suppose there’re some numbers given on column “A”, I want to print whether
> the number is Odd or Even in column “E” using Arrays, my code is working but
> printing wrong values, instead of printing “Even Number” for an even number
> it is printing “Odd Number”, there can be a logical error in the code.
>
>
>
> All The Best.. J
>
>
>
> Thanks & Regards
>
> Deepak
>
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


ctv_Even and Odd.xls
Description: MS-Excel spreadsheet

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

2011-04-25 Thread ashish koul

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 deactive
> it is not working as we think.that's why I posted it.Will u pls send
> attached sheet with the macro u mentioned.If so I can understand what
> is the fault I made.
> Regards
>
> Rajesh kainikkara
>
>
>
> On 4/21/11, Paul Schreiner  wrote:
> > You really need to create two event macros.
> > the workbook_activate event would go to full screen when you "select" the
> > workbook,
> > if you use a workbook_deactivate macro to change the displayfullscreen to
> > "false",
> > it will revert to "normal" for when in any other workbook or window.
> >
> > Paul
> >
> >
> >
> >
> > 
> > From: ChilExcel 
> > To: excel-macros@googlegroups.com
> > Sent: Wed, April 20, 2011 12:43:36 PM
> > Subject: Re: $$Excel-Macros$$ Show full screen for a particular workbook
> > only.
> >
> >
>  > You need add ins ?
> >
> >
> >
> >
> > 2011/4/20 rajan verma 
> >
> > make it add-ins
> >>
> >>
> >>
> >>On Fri, Apr 15, 2011 at 5:16 PM, Rajesh K R 
> >> wrote:
> >>
> >>Hi Experts,
> >>>
> >>>I gave the following code to get the full screen view, if it is only
> >>>applicable to that particular workbook how can i change it.
> >>>
> >>>
> >>>Private Sub Workbook_Open()
> >>>Application.DisplayFullScreen = True
> >>>End Sub
> >>>
> >>>Regards
> >>>Rajesh kainikkara
> >>>
> >>>--
>
> >>>--
> >>>
> >>>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
> >>>
> >>><><><><><><><><><><><><><><><><><><><><><><>
> >>>Like our page on facebook , Just follow below link
> >>>http://www.facebook.com/discussexcel
> >>>
> >>
> >>
> >>--
> >>Regards
> >>Rajan verma
> >>+91 9158998701
> >>
> >>--
>
> >>--
> >>
> >>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
> >>
> >><><><><><><><><><><><><><><><><><><><><><><>
> >>Like our page on facebook , Just follow below link
> >>http://www.facebook.com/discussexcel
> >>
> >
> >
> > --
> >
> > Visita ; http://sites.google.com/site/chilexcel/Home
> > Visita ; http://www.youtube.com/user/timextag41
> > --
> >
> --
> >
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
> > --
> >
> --
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
> --
>
> --
> 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.linke

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

2011-04-25 Thread ashish koul

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 attached but I am not able to get this
> add to new workbook.
>
>
>
> Kindly help in this regard.
>
>
>
> Regards,
>
>
>
> Vikram
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *jmothilal
> *Sent:* Saturday, April 23, 2011 12:03 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Excel spell out word from number
>
>
>
> 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 spreadsheet with a column of numbers.  I would like
> each number to be
> spelled out, for example
>
> B1=4
> C1=four
>
> B2=99
> C2=ninety-nine.
>
> How would I go about this with a macro?
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> --
> J.Mohilal
> Universal Computer Systems
> # 16, Brindavan Complex
> Otteri, Vellore-2
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-04-25 Thread jmothilal

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 Security Medium

Mothilal.J



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 attached but I am not able to get this
> add to new workbook.
>
>
>
> Kindly help in this regard.
>
>
>
> Regards,
>
>
>
> Vikram
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *jmothilal
> *Sent:* Saturday, April 23, 2011 12:03 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Excel spell out word from number
>
>
>
> 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 spreadsheet with a column of numbers.  I would like
> each number to be
> spelled out, for example
>
> B1=4
> C1=four
>
> B2=99
> C2=ninety-nine.
>
> How would I go about this with a macro?
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> --
> J.Mohilal
> Universal Computer Systems
> # 16, Brindavan Complex
> Otteri, Vellore-2
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Rupees-words.bas
Description: Binary data

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

2011-04-25 Thread BADAL SINGH

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 spreadsheet with a column of numbers.  I would like
>> each number to be
>> spelled out, for example
>>
>> B1=4
>> C1=four
>>
>> B2=99
>> C2=ninety-nine.
>>
>> How would I go about this with a macro?
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> J.Mohilal
> Universal Computer Systems
> # 16, Brindavan Complex
> Otteri, Vellore-2
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*BADAL SINGH*
*09631444534*

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

2011-04-25 Thread jocky Beta

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
sheet ?



Regards,

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ help

2011-04-25 Thread vijayajith VA

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


help requ.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

2011-04-25 Thread 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
> 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 at 7:14 PM, karan kanuga 
> wrote:
> > > Hi,
> >
> > > Can any1 pls let me know how do i separate the text and nos in a
> > > given sentence. PFA the sheet where i need to separate the nos and
> text.
> >
> > > 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 group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/discussexcel
> >
> > --
> > *Regards*
> > * *
> > *Ashish Koul*
> > *akoul*.*blogspot*.com 
> > *akoul*.wordpress.com 
> > My Linkedin Profile 
> >
> > P Before printing, think about the environment.
> >
> >  extract_nos_from_text(1).xls
> > 42KViewDownload- Hide quoted text -
> >
> > - Show quoted text -
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help

2011-04-25 Thread ashish koul

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
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Multiple file Formatting

2011-04-25 Thread Chidurala, Shrinivas

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 files at a time, if i save all files in specific folder.

Find attached sample file for your reference.

Thanks in Advance

Regards,
Shrinivas

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Sub outflow_ft()

Cells.Select
With Selection
.WrapText = True
.RowHeight = 25
.ColumnWidth = 25
.MergeCells = False
.Interior.ColorIndex = xlNone
End With
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.ClearContents
Selection.End(xlDown).Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
ActiveWindow.DisplayGridlines = False
   Range("B:B, D:D, F:F, J:J, M:N,T:T,W:W, Z:Z ").Select
Selection.Delete Shift:=xlToLeft

Range("A1").Select

ActiveWorkbook.Save
ActiveWorkbook.Close


End Sub


WEEKLYCAANNMIRAI-4209788.XLS
Description: WEEKLYCAANNMIRAI-4209788.XLS

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

2011-04-25 Thread roberto mensa

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
>> 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 at 7:14 PM, karan kanuga 
>> wrote:
>> > > Hi,
>> >
>> > > Can any1 pls let me know how do i separate the text and nos in a
>> > > given sentence. PFA the sheet where i need to separate the nos and
>> text.
>> >
>> > > 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 group @
>> http://www.linkedin.com/groups?gid=1871310
>> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>> >
>> > > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > > <><><><><><><><><><><><><><><><><><><><><><>
>> > > Like our page on facebook , Just follow below link
>> > >http://www.facebook.com/discussexcel
>> >
>> > --
>> > *Regards*
>> > * *
>> > *Ashish Koul*
>> > *akoul*.*blogspot*.com 
>> > *akoul*.wordpress.com 
>> > My Linkedin Profile 
>> >
>> > P Before printing, think about the environment.
>> >
>> >  extract_nos_from_text(1).xls
>> > 42KViewDownload- Hide quoted text -
>> >
>> > - Show quoted text -
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


extract+nos+from+text.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

2011-04-25 Thread cjesag


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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

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

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

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

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

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

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

$$Excel-Macros$$ help

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

Re: $$Excel-Macros$$ help

$$Excel-Macros$$ Multiple file Formatting

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

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

12 matches

Site Navigation

Mail list logo

Footer information