date:20101228

Re: $$Excel-Macros$$ how to get month Occurrence in no.

2010-12-28 Thread Manoj kumar

try this..

Function convertMonthName2Number(monthName As String) As Integer

' try to convert month name to actual date type
Dim dtestr As String
dtestr = monthName & "/1/2000"

Dim dte As Date
On Error Resume Next
dte = CDate(dtestr)

If Err.Number <> 0 Then
  convertMonthName2Number = -999
  Exit Function
End If
On Error GoTo 0

convertMonthName2Number = Month(dte)
End Function


OR you can refer this :-
http://www.codeforexcelandoutlook.com/blog/2009/04/converting-month-name-to-number/



Regards,
Manoj

On Tue, Dec 28, 2010 at 12:26 PM, Rohan Young  wrote:

> Hi experts,
>
> is there any formula, if i only type in cell April and the other cell
> return the value 4, remember if i type simply April not 04/01/2010 etc. etc.
>
> please provide your feedback
>
>
> thanks & regards
>
> ROHAN
> 9818247278, 8860567680
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Nested IF functions?

2010-12-28 Thread hanumant shinde

i dont understand what u mean exactly but i will jus tell u abt nested if in 
excel. let me know if you wanna know nesed if for Macro.

it is if else function.
so write if and give some value if is its true and in place of else write 
another if.
if you wanna know the syntax refer help in excel. just type in IF and you will 
get everything there.

e.g.
=IF(A3=3,"Equal",IF(A3<3,"Less",IF(A3>3,"Greater")))


explaination 
if A3 = 3 value wil be "Equal"
if A3<3 then value will be "Less"
if A3<3 then value will be "Greater"



- Original Message 
> From: J D 
> To: MS EXCEL AND VBA MACROS 
> Sent: Tue, 28 December, 2010 7:36:57 AM
> Subject: $$Excel-Macros$$ Nested IF functions?
> 
> I am a concrete estimator who is trying to create some cut and paste
> Estimate  line items I can just grab from one spread sheet and paste in
> to my  estimate.
> 
> I was refining one and tried to use the IF function to pick the  number
> of labor hours based on sq footage.  More s.f. and we are  more
> productive therefore less hours per s.f.
> 
> I was trying to say if  less that 500 s.f. then .035 hrs/s.f.  500 to
> 1,000 then .0275 hrs/s.f.  >1,000 s.f. then .0225 hours/s.f.
> 
> I could get one working but wanted  to know how to get more going
> choises out of one formula.  Attached is  the assembly and the formula
> below it.
> 
> 
> Form, place and finish ~  (__) s.f. of 4" broom swept finish concrete
> sidewalk.  Concrete to be  3,500 psi and reinforced with 6 x 6 , w1.4/
> w1.4 wwf.   $4,410.00
> Area990 s.f.Perimeter114 l.f.
> Concrete9900.33 1.03336.50112.463 131451885
> Labor 130.45.2 5.240 208
> wwf99040 24.75 257175
> 2" SB 9900.26257.4 260 0.49127.4
> Labor990 0.0032.97 340 120
> Poly9901800 0.55 0.68551
> Labor 9900.0021.98 240 80
> Expansion9900.25 247.51002.475 2.531.6479.1
> Labor 2500.012.5 2.540 100
> Curing640350 1.82857142950.365714286 0.45522
> Labor 9900.0032.97 340 120
> 2 x 411416 7.125 85.8146.48
> Labor 1140.3337.62 0.27.5247.6 40304
> Finish990 1009.92.75 27.22527.340 1092
> 
> 
> 
>   4409.98
> =IF(B16<500,3.5,2.75)
> 
> -- 
>--
>-
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
> 


-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ how to get month Occurrence in no.

2010-12-28 Thread STDEV(i)

other stuff

=MONTH(DATEVALUE("1 "&A1&" 2010"))



On Tue, Dec 28, 2010 at 3:34 PM, siti Vi  wrote:

> If  the word "April" or *another month name *is type correctly in cell A1
> try this formula in B1
>
> =TEXT(DATEVALUE("1 "&A1&" 2010"),"M")
>
>
>
>
> On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young  wrote:
>
>> Hi experts,
>>
>> is there any formula, if i only type in cell April and the other cell
>> return the value 4, remember if i type simply April not 04/01/2010 etc. etc.
>>
>> please provide your feedback
>>
>> thanks & regards
>>
>> ROHAN
>> 9818247278, 8860567680
>>
>>
>>
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ how to get month Occurrence in no.

2010-12-28 Thread siti Vi

If  the word "April" or *another month name *is type correctly in cell A1
try this formula in B1

=TEXT(DATEVALUE("1 "&A1&" 2010"),"M")



On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young  wrote:

> Hi experts,
>
> is there any formula, if i only type in cell April and the other cell
> return the value 4, remember if i type simply April not 04/01/2010 etc. etc.
>
> please provide your feedback
>
> thanks & regards
>
> ROHAN
> 9818247278, 8860567680
>
>
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ how to get month Occurrence in no.

2010-12-28 Thread Dave Bonallack


Hi,
A shorter version would be:
=MONTH(--(1&A1))
This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended 
abbreviations (eg Sept) and also unabbreviated (eg June, November)
Regards - Dave.
 


Date: Tue, 28 Dec 2010 15:34:01 +0700
Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no.
From: villager.g...@gmail.com
To: excel-macros@googlegroups.com

If  the word "April" or another month name is type correctly in cell A1
try this formula in B1

=TEXT(DATEVALUE("1 "&A1&" 2010"),"M")




On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young  wrote:

Hi experts,


is there any formula, if i only type in cell April and the other cell return 
the value 4, remember if i type simply April not 04/01/2010 etc. etc.


please provide your feedback



thanks & regards


ROHAN
9818247278, 8860567680



-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
  

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ how to get month Occurrence in no.

2010-12-28 Thread Dilip Pandey

Impressive ..!!
Good show Dave, Siti, STDEV :)

Best Regards,
DILIPandey

On Tue, Dec 28, 2010 at 4:13 PM, Dave Bonallack
wrote:

> Hi,
> A shorter version would be:
> =MONTH(--(1&A1))
> This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended
> abbreviations (eg Sept) and also unabbreviated (eg June, November)
> Regards - Dave.
>
> --
> Date: Tue, 28 Dec 2010 15:34:01 +0700
> Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no.
> From: villager.g...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> If  the word "April" or *another month name *is type correctly in cell A1
> try this formula in B1
>
> =TEXT(DATEVALUE("1 "&A1&" 2010"),"M")
>
>
>
> On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young  wrote:
>
> Hi experts,
>
> is there any formula, if i only type in cell April and the other cell
> return the value 4, remember if i type simply April not 04/01/2010 etc. etc.
>
> please provide your feedback
>
>  thanks & regards
>
> ROHAN
> 9818247278, 8860567680
>
>
>
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Thanks & Regards,

DILIP KUMAR PANDEY
  MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column

2010-12-28 Thread Daniel

Hi,
Try :

Sub test2()
Dim Col As Integer, c As Range, Line As Long
Dim inCalculationMode As Integer
Application.ScreenUpdating = False
inCalculationMode = Application.Calculation
Application.Calculation = xlCalculationManual
Col = Cells(1, Columns.Count).End(xlToLeft).Column
Line = Cells(Cells.Rows.Count, 1).End(xlUp).Row + 1
For i = 2 To Col
Range(Cells(1, i), Cells(Cells.Rows.Count, i).End(xlUp)).Copy _
Cells(Line, 1)
Line = Cells(Cells.Rows.Count, 1).End(xlUp).Row + 1
Next i
Application.Calculation = inCalculationMode
Application.ScreenUpdating = True
End Sub

Regards.

Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Financeguy
Envoyé : dimanche 26 décembre 2010 00:30
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One
Column

Hi,

I'm trying to select one range at a time for each individual column within a
single worksheet.  I have range data in approximately 150 columns on the
worksheet that I would like to sort individually (ascending order), then
cut, and finally paste into the last row of Column A.

For example, if I had data on a sheet, like A1:A13000, B1:B1453,
C1:C1232...and so on... till say CC1:CC1535I'd like to cut each
rangeB1:B14535, and paste it below A13000.and so on..

It is cumbersome to do it manually, and I would love some VBA code that
could help me with accomplish this.

Many thanks in advance,

Finance guy

--

--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ Amount Format

2010-12-28 Thread Daniel

Please, see attached file.
Regards.
Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Rajiv Kumar
Envoyé : lundi 20 décembre 2010 15:11
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Amount Format

Dear sir how can I write excel sheet dis format 1,85,000 in excel.

 It yes then please give me tips. Awating your positive replay…




Raj

--

--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


Number Format.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Nested IF functions?

2010-12-28 Thread Dilip Pandey

Hi J D,

It would be really appreciable if you can share a test file on this.  Help
us to help you :)

Best Regards,
DILIPandey

On Tue, Dec 28, 2010 at 7:36 AM, J D  wrote:

> I am a concrete estimator who is trying to create some cut and paste
> Estimate line items I can just grab from one spread sheet and paste in
> to my estimate.
>
> I was refining one and tried to use the IF function to pick the number
> of labor hours based on sq footage.  More s.f. and we are more
> productive therefore less hours per s.f.
>
> I was trying to say if less that 500 s.f. then .035 hrs/s.f.  500 to
> 1,000 then .0275 hrs/s.f. >1,000 s.f. then .0225 hours/s.f.
>
> I could get one working but wanted to know how to get more going
> choises out of one formula.  Attached is the assembly and the formula
> below it.
>
>
> Form, place and finish ~ (__) s.f. of 4" broom swept finish concrete
> sidewalk.  Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/
> w1.4 wwf.
> $4,410.00
>Area990 s.f.Perimeter   114 l.f.
> Concrete990 0.331.03336.501 12.463  13  145
> 1885
> Labor   13  0.4 5.2 5.2 40  208
> wwf 990 40  24.75   25  7   175
> 2" SB   990 0.26257.4   260 0.49127.4
> Labor   990 0.003   2.973   40  120
> Poly990 18000.550.6 85  51
> Labor   990 0.002   1.982   40  80
> Expansion   990 0.25247.5   100 2.475   2.5 31.64
> 79.1
> Labor   250 0.012.5 2.5 40  100
> Curing  640 350 1.828571429 5   0.365714286 0.4 55
>  22
> Labor   990 0.003   2.973   40  120
> 2 x 4   114 16  7.125   8   5.8146.48
> Labor   114 0.3337.62   0.2 7.524   7.6 40  304
> Finish  990 100 9.9 2.7527.225  27.340  1092
>
>
>
>4409.98
> =IF(B16<500,3.5,2.75)
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Thanks & Regards,

DILIP KUMAR PANDEY
  MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column

2010-12-28 Thread Daniel

I forgot to sort the columns :

Sub test2()
Dim Col As Integer, c As Range, Line As Long
Dim inCalculationMode As Integer
Application.ScreenUpdating = False
inCalculationMode = Application.Calculation
Application.Calculation = xlCalculationManual
Col = Cells(1, Columns.Count).End(xlToLeft).Column
Line = Cells(Cells.Rows.Count, 1).End(xlUp).Row + 1
Set rg = Range(Cells(1, 1), Cells(Cells.Rows.Count, 1).End(xlUp))
rg.Sort key1:=rg(1, 1), order1:=xlAscending
For i = 2 To Col
Set rg = Range(Cells(1, i), Cells(Cells.Rows.Count, i).End(xlUp))
rg.Sort key1:=rg(1, 1), order1:=xlAscending
rg.Copy Cells(Line, 1)
Line = Cells(Cells.Rows.Count, 1).End(xlUp).Row + 1
Next i
Application.Calculation = inCalculationMode
Application.ScreenUpdating = True
End Sub

Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Financeguy
Envoyé : dimanche 26 décembre 2010 00:30
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One
Column

Hi,

I'm trying to select one range at a time for each individual column within a
single worksheet.  I have range data in approximately 150 columns on the
worksheet that I would like to sort individually (ascending order), then
cut, and finally paste into the last row of Column A.

For example, if I had data on a sheet, like A1:A13000, B1:B1453,
C1:C1232...and so on... till say CC1:CC1535I'd like to cut each
rangeB1:B14535, and paste it below A13000.and so on..

It is cumbersome to do it manually, and I would love some VBA code that
could help me with accomplish this.

Many thanks in advance,

Finance guy

--

--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ Macro security help

2010-12-28 Thread Daniel

Hello,
2.
If ActiveCell.HasFormula Then
msgbox "The active cell contains a formula"
End If

Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de hanumant shinde
Envoyé : samedi 18 décembre 2010 22:00
À : Excel Group
Objet : $$Excel-Macros$$ Macro security help

hey guys i think this must tough.

1. is there any functionality through which i can get to know if anybody has
done Alt +F11 i.e. edit on my macro.

2. how can i get to know if a specific /cells have formula or value?

thanks,
hanumant 



--

--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ how to get month Occurrence in no.

Re: $$Excel-Macros$$ Nested IF functions?

Re: $$Excel-Macros$$ how to get month Occurrence in no.

Re: $$Excel-Macros$$ how to get month Occurrence in no.

RE: $$Excel-Macros$$ how to get month Occurrence in no.

Re: $$Excel-Macros$$ how to get month Occurrence in no.

RE: $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column

RE: $$Excel-Macros$$ Amount Format

Re: $$Excel-Macros$$ Nested IF functions?

RE: $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column

RE: $$Excel-Macros$$ Macro security help

11 matches

Site Navigation

Mail list logo

Footer information