date:20101030

Re: $$Excel-Macros$$ Re: Help Required!

2010-10-30 Thread roberto mensa

the sub test is just one example of how to use the function into a routine.

Sub test()
Dim s As String
s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
s = ProperCase_r(s)
Debug.Print s
End Sub

r

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

$$Excel-Macros$$ guide line in excell

2010-10-30 Thread sohail najam

Hi,

I am  Najam , I need ur guidence for in excel sheet

 suppose i have an excell file with 30 sheets for thirty  branches with the
same variables . now  ineed to add suppose  the data of all  cell A1 for
each sheet in a new sheet called total inA1 cell.
one sol is i start adding a1 cell for all sheet in total sheet in same cell
a1.its long procedure .
any short method.

kindly guide me

Thanks & best wishes for nice group
najam

-- 
--
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 to Go From One Cell to Another

2010-10-30 Thread sohail najam

Hi,

I am  Najam , I need ur guidence for in excel sheet

 suppose i have an excell file with 30 sheets for thirty  branches with the
same variables . now  ineed to add suppose  the data of all  cell A1 for
each sheet in a new sheet called total inA1 cell.
one sol is i start adding a1 cell for all sheet in total sheet in same cell
a1.its long procedure .
any short method.

kindly guide me

Thanks & best wishes for nice group
najam

-- 
--
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$$ finding the last row

2010-10-30 Thread Maries

Hi Lakshitha,

*Use the following code:*
**
Sub FindLastRow()
Dim LastRow As Long
If WorksheetFunction.CountA(Cells) > 0 Then
'Search for any entry, by searching backwards by Rows.
LastRow = Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByRows,
SearchDirection:=xlPrevious).Row
  MsgBox LastRow
End If
End Sub


*For information, check below link:*

http://www.ozgrid.com/VBA/ExcelRanges.htm
Regards,
Maries
On Sat, Oct 30, 2010 at 2:54 PM, Lakshitha  wrote:

> I have a excel sheet where, data is distributed. I want my macro to
> find the last non empty row in the sheet. what is the best way to find
> it.
>
> In several places i saw that , "go to special --> last cell" is not
> that reliable.
>
> --
>
> --
> 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$$ Novice Needs Help with Basic Excel Print Macro/VBA for Church Project

2010-10-30 Thread MT

Thank You so much!!!

On Oct 30, 8:11 am, "Daniel"  wrote:
> Hello.
> Try :
> Sub ConditionalPrint()
> Sheets("Offering").PrintOut
> If ['General Check Continuation'!I136] > 0 Then
>     Sheets("General Check Continuation").PrintOut
> End If
> End Sub
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
> la part de MT
> Envoyé : samedi 30 octobre 2010 08:37
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA
> for Church Project
>
> Hello. I have (2) worksheets in my Excel Workbook; "Offering" and "General
> Check Continuation". Could someone please help me with the code to be able
> to print the work sheet "Offering" and also worksheet "General Check
> Continuation" only if cell I36 on "General Check Continuation" is greater
> than 0 otherwise I need it to just print the worksheet "Offering". Thank you
> Much!
>
> --
> ----
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip2. 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.com5. 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 
> linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...

-- 
--
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$$ Novice Needs Help with Basic Excel Print Macro/VBA for Church Project

2010-10-30 Thread MT

Thank You Daniel!


On Oct 30, 8:11 am, "Daniel"  wrote:
> Hello.
> Try :
> Sub ConditionalPrint()
> Sheets("Offering").PrintOut
> If ['General Check Continuation'!I136] > 0 Then
>     Sheets("General Check Continuation").PrintOut
> End If
> End Sub
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
> la part de MT
> Envoyé : samedi 30 octobre 2010 08:37
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA
> for Church Project
>
> Hello. I have (2) worksheets in my Excel Workbook; "Offering" and "General
> Check Continuation". Could someone please help me with the code to be able
> to print the work sheet "Offering" and also worksheet "General Check
> Continuation" only if cell I36 on "General Check Continuation" is greater
> than 0 otherwise I need it to just print the worksheet "Offering". Thank you
> Much!
>
> --
> ----
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip2. 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.com5. 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 
> linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...

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

$$Excel-Macros$$ Macro to Go From One Cell to Another

2010-10-30 Thread MT

I have a worksheet called "Offering" and was wondering how do I make a
Macro to go from say cell C35 to E26 on that worksheet after I exit
C35 whether C35 was changed or not. If C35 absolutely has to be
changed to make it work, that would be OK. In Access you can sort the
"Tab Order" and pick which field the cursor hops to next. I would also
like to be like to be able to do the same from a merged cell E8:G8 to
C11. Please dumb down any answer because as I don't know VBA very
well. Thank You!

-- 
--
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$$ manage lengthy database

2010-10-30 Thread ashish koul

Sub Macro1()
If ActiveSheet.AutoFilterMode = True Then
ActiveSheet.AutoFilterMode = False
End If

ActiveSheet.Range("$A$1:$B$27").AutoFilter Field:=2, Criteria1:= _
">=" & CDate(Range("g4").Value), Operator:=xlAnd, Criteria2:="<=" &
CDate(Range("g5").Value)
End Sub






On Sat, Oct 30, 2010 at 7:12 PM, Rajesh K R wrote:

> Hi Experts
> thanks for ur promt reply.is it possible to give the from & to dates
> for filtering in specified cells and filter it by a macro eg:
>
>  Sub applyfilter()
> > If ActiveSheet.AutoFilterMode = True Then
> > ActiveSheet.AutoFilterMode = False
> > End If
> > ActiveSheet.Range("$A$1:$B$27").AutoFilter Field:=2, Criteria1:= _
> > ">=$d$1", Operator:=xlAnd, Criteria2:="<=$e$1"
> > End Sub
>
> Regards
> Rajesh Kainikkara
>
> On 10/28/10, ashish koul  wrote:
> > Sub applyfilter()
> > If ActiveSheet.AutoFilterMode = True Then
> > ActiveSheet.AutoFilterMode = False
> > End If
> > ActiveSheet.Range("$A$1:$B$27").AutoFilter Field:=2, Criteria1:= _
> > ">=10/31/2010", Operator:=xlAnd, Criteria2:="<=11/18/2010"
> > End Sub
> >
> > Sub RemoveFilter()
> >
> > If ActiveSheet.AutoFilterMode = True Then
> > ActiveSheet.AutoFilterMode = False
> > End If
> >
> > End Sub
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On Thu, Oct 28, 2010 at 4:44 PM, P.VIJAYKUMAR 
> wrote:
> >
> >> Hi Rakesh,
> >>
> >>
> >> You can also change gridline colour or give colours to the cells in
> which
> >> you want to see your Cursor.To change thecoulour of gridline(if you are
> >> using excel 2007) Go to the Excel ribbon Button then go to the Excel
> >> option
> >> Button In that go to  that advanced option. In that advanced option go
> to
> >> the Display options in that in the end you will have chage gridline
> >> Colour.you can select what ever coulour you want excep dark colours
> >> because
> >> dark clours Mix withthe cursor  colour and you  will get confused,
> >>
> >>
> >>
> >> Regards,
> >> VijayKumar
> >>
> >> On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R
> >> wrote:
> >>
> >>> Hi experts
> >>>
> >>> Any one can help me to manage my problem to work in the lengthy
> database,
> >>> eg if selected a raw having a lot of field i am mistaken many times to
> >>> identify the related name field. pls find the attachment regarding the
> >>> problem & help me to find a solution.
> >>>
> >>> Expecting your valuable advise
> >>>
> >>> Regards
> >>>
> >>> Rajesh
> >>>
> >>> --
> >>>
> >>>
> --
> >>> 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
> >>>
> >>
> >>
> >>
> >> --
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> P.VIJAY KUMAR
> >>
> >>   --
> >>
> >>
> --
> >> 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
> >>
> >
> >
> >
> > --
> > *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@googl

RE: $$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA for Church Project

2010-10-30 Thread Daniel

Hello.
Try :
Sub ConditionalPrint()
Sheets("Offering").PrintOut
If ['General Check Continuation'!I136] > 0 Then
Sheets("General Check Continuation").PrintOut
End If
End Sub
Regards.
Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de MT
Envoyé : samedi 30 octobre 2010 08:37
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA
for Church Project

Hello. I have (2) worksheets in my Excel Workbook; "Offering" and "General
Check Continuation". Could someone please help me with the code to be able
to print the work sheet "Offering" and also worksheet "General Check
Continuation" only if cell I36 on "General Check Continuation" is greater
than 0 otherwise I need it to just print the worksheet "Offering". Thank you
Much!

--

--
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$$ manage lengthy database

2010-10-30 Thread Rajesh K R

Hi Experts
thanks for ur promt reply.is it possible to give the from & to dates
for filtering in specified cells and filter it by a macro eg:

 Sub applyfilter()
> If ActiveSheet.AutoFilterMode = True Then
> ActiveSheet.AutoFilterMode = False
> End If
> ActiveSheet.Range("$A$1:$B$27").AutoFilter Field:=2, Criteria1:= _
> ">=$d$1", Operator:=xlAnd, Criteria2:="<=$e$1"
> End Sub

Regards
Rajesh Kainikkara

On 10/28/10, ashish koul  wrote:
> Sub applyfilter()
> If ActiveSheet.AutoFilterMode = True Then
> ActiveSheet.AutoFilterMode = False
> End If
> ActiveSheet.Range("$A$1:$B$27").AutoFilter Field:=2, Criteria1:= _
> ">=10/31/2010", Operator:=xlAnd, Criteria2:="<=11/18/2010"
> End Sub
>
> Sub RemoveFilter()
>
> If ActiveSheet.AutoFilterMode = True Then
> ActiveSheet.AutoFilterMode = False
> End If
>
> End Sub
>
>
>
>
>
>
>
>
>
>
>
>
> On Thu, Oct 28, 2010 at 4:44 PM, P.VIJAYKUMAR  wrote:
>
>> Hi Rakesh,
>>
>>
>> You can also change gridline colour or give colours to the cells in which
>> you want to see your Cursor.To change thecoulour of gridline(if you are
>> using excel 2007) Go to the Excel ribbon Button then go to the Excel
>> option
>> Button In that go to  that advanced option. In that advanced option go to
>> the Display options in that in the end you will have chage gridline
>> Colour.you can select what ever coulour you want excep dark colours
>> because
>> dark clours Mix withthe cursor  colour and you  will get confused,
>>
>>
>>
>> Regards,
>> VijayKumar
>>
>> On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R
>> wrote:
>>
>>> Hi experts
>>>
>>> Any one can help me to manage my problem to work in the lengthy database,
>>> eg if selected a raw having a lot of field i am mistaken many times to
>>> identify the related name field. pls find the attachment regarding the
>>> problem & help me to find a solution.
>>>
>>> Expecting your valuable advise
>>>
>>> Regards
>>>
>>> Rajesh
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> P.VIJAY KUMAR
>>
>>   --
>>
>> --
>> 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
>>
>
>
>
> --
> *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/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 p

Re: $$Excel-Macros$$ Parsing a range to an array

2010-10-30 Thread frank

Hello,
You can also loop through the various selected areas and process
the cells as needed.

dim rngCell as Range

For Each rngCell In Selection.Areas
varXRange() = rngCell
Next





On Oct 28, 4:30 am, Dave Bonallack  wrote:
> Hi,
> You can test for a non-contiguous selection with the following line of code:
> A = Selection.Areas.Count
>
> Use this in an If statement - eg
> If Selection.Areas.Count > 1 then msgbox "You can't use non-contiguous 
> cells.": Exit Sub
>
> Hope this helps.
> Regards - Dave.
>
>
>
> > Date: Thu, 28 Oct 2010 00:28:29 -0700
> > Subject: $$Excel-Macros$$ Parsing a range to an array
> > From: mr.frog.to@googlemail.com
> > To: excel-macros@googlegroups.com
>
> > Hi Everyone,
>
> > I am building a series of wizards for handling some internal processes
> > at my office. We are extracting data from from '3rd party' data
> > sources into excel worksheets. To further process this data by hand is
> > slow, so I was asked to write a few macros etc to speed things up. The
> > issue I am facing is occuring when the user selects the specific cells
> > they want to use for a particular wizard / process.
>
> > When the user selects contiguous cells, cells that are next to each
> > other, then all is fine when using the processes. I am letting the
> > user choose the cells via the ref object on a user form. The user
> > sometimes chooses cells that are not next to each other, cells in the
> > same column but not right next to each other for example. This causes
> > me a problem in handling the data and breaks my code. I am grabbing
> > the data as follows:
>
> > varXRange() = Range(refXRange)
>
> > This normally retuns me an array in R1C1 type 'layout', and is
> > extremely useful for processing large volumes of data at speed. What I
> > am trying to do is to find a way to achieve the same, but with non
> > contiguous ranges. I was thinking of simply searching the string that
> > the ref object returns for commas, then process each chunk separately
> > adding it to an array, but was wondering if someone already has an
> > approach to solving this?
>
> > Any thoughts would be appreciated
>
> > Cheers
>
> > The Frog
>
> > --
> > ------
> > 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/pages/discussexcelcom/160307843985936?v=wall&...- 
> >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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ finding the last row

2010-10-30 Thread Lakshitha

I have a excel sheet where, data is distributed. I want my macro to
find the last non empty row in the sheet. what is the best way to find
it.

In several places i saw that , "go to special --> last cell" is not
that reliable.

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

$$Excel-Macros$$ VBA Controls are missing for some users

2010-10-30 Thread frank

Hello,
   I added some controls to a worksheet and they work fine on some
computers, but on other computers the controls are not visible. The
controls are 2 Calendar 11 controls I inserted using the Insert -
Object menu. There is also a combobox, a command button, and two
checkboxes that were added from the VBA Toolbox.
   All computers have Excel 2003 Professional. The references are
identical on all computers when viewed from the VBA Tools/References
menu.
  When my user first opened the sheet on her computer she could see
none of the controls.
I logged in as Admin and when I opened the sheet on her computer,
Windows ran some converter that I had never seen before. I could then
see the controls.
My user logged back in and she can now see the Calenders but not the
VBA Toolbox controls.
I am considering temporarily giving her admin privileges and seeing if
the controls will work for her afterwards.
Any suggestions would be much appreciated.
I've wondered if it would be better to create a form for the controls,
but I would like to leave them on the worksheet if possible.
What libraries should I chose for my project to have the best
compatibility with other excel 2003 installations?
I only need those few controls of calendar, checkbox, command button.

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

Re: $$Excel-Macros$$ Re: Help Required!

2010-10-30 Thread amrahs k

Hi,

I meant to say every time I need to change the "S" value as Input which is
taking more time.

I am unable to copy the result since it is showed via message box. I want to
copy the result and updated in documents.

It would be helpful if you could change the code as per the need.(Macro have
to replace the input with the output instead of populating through message
box.)
Thanks,
Sharma
On Thu, Oct 28, 2010 at 3:41 PM, roberto mensa  wrote:

> I don't understand
> which linguage do you use?
> In visual basic as I have proposed is a function you can pass any text and
> use its result
>
>
> regards
> r
>
>
>
>
> 2010/10/28 amrahs k 
>
>>   Hi,
>>
>> This works great. Thanks for your efforts and help. Though I have a small
>> need as well.
>>
>> The code gives the output through message box. Due to this I am unable to
>> copy the value (i.e) Output.
>>
>> Also the code is only execute for the input "AGREEMENT. THE ADOPTION THE
>> ADULT OR MARRIED MINOR". What I need to have is to applicable for any kind
>> of inputs (i.e) the input value is not constant it may change as per the
>> user requirement.
>>
>> Please help me to overcome this and many thanks in advance.
>>
>> Regards,
>> Sharma
>>
>>On Wed, Oct 27, 2010 at 9:49 PM, r  wrote:
>>
>>> try this function:
>>>
>>> Function ProperCase_r( _
>>> ByVal s As String) As String
>>> '__
>>> '¯¯
>>> 'https://sites.google.com/site/e90e50/vbscript/regexp
>>> '__
>>> '¯¯
>>> Dim v, i As Long, x
>>> Dim re As Object
>>> Set re = CreateObject("vbscript.regexp")
>>> re.Global = True
>>>
>>> s = VBA.StrConv(s, vbProperCase)
>>> v = Split("an|a|the|or|and|on|over|abore|" & _
>>>"under|blow|between|near|beside|among", "|")
>>>
>>> For Each x In v
>>>re.Pattern = "\b" & VBA.StrConv(x, vbProperCase) & "\b"
>>>s = re.Replace(s, x)
>>> Next
>>> Debug.Print s
>>> re.Pattern = _
>>> "(^|[.!?]\b|[.!?]\s+\b|\r\b|\f\b|\n\b)(.)"
>>>
>>> ProperCase_r = _
>>> re.Replace(s, "$1§$2§")
>>> v = Split(ProperCase_r, _
>>> "§", , vbTextCompare)
>>> For i = 1 To UBound(v) Step 2
>>> v(i) = VBA.StrConv(v(i), vbUpperCase)
>>> Next
>>> ProperCase_r = Join(v, "")
>>> End Function
>>>
>>> Sub test()
>>> Dim s As String
>>> s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
>>> MsgBox ProperCase_r(s)
>>> End Sub
>>>
>>> regards
>>> r
>>>
>>>
>>> On 27 Ott, 11:25, amrahs k  wrote:
>>> > Hi Team,
>>> >
>>> > I want a macro in MS word that will do the following.
>>> >
>>> > It will first convert the upper case into title case and then replace
>>> every
>>> > connecting word with lower case.
>>> >
>>> > *Example:*  AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR
>>> >
>>> > *Required Output:*  Agreement. The Adoption the Adult or Married Minor
>>> >
>>> > *Note:* The connecting word “THE” has been replaced by “the” however
>>> the
>>> > macro left the first connecting word “THE” that followed by dot (.)
>>> >
>>> > Your help would be greatly appreciated.
>>> >
>>> > Thanks,
>>> > Sharma
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
> --
>
> --
> 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-ma

Re: $$Excel-Macros$$ Fwd: Practice

2010-10-30 Thread neil johnson

Hi Robert,

Thanks

On Wed, Oct 27, 2010 at 2:22 AM, roberto mensa  wrote:

> try:
>
> Private Sub CommandButton1_Click()
> Dim item, rng As Excel.Range
> For item = 0 To ListBox1.ListCount - 1
> If Me.ListBox1.Selected(item) = True Then
> Set rng = Sheet2.Range("A" & Rows.Count). _
> End(xlUp).Offset(1, 0)
> rng.Value = Me.ListBox1.List(item, 0)
> rng.Offset(, 1) = Me.ListBox1.List(item, 1)
> End If
> Next
> End Sub
>
> regards
> r
>
>
>
> 2010/10/26 neil johnson 
>
>
>> Hi Everyone,
>>
>> I need your help. I make listbox using user form in excel . in listbox
>> there is data from sheet 3 . now i transfer selected data to sheet 2 . it is
>> working but not in proper manner . when i select data it shows data  in cell
>> A range not completely . Please help me
>>
>> 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/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
>

-- 
--
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$$ Fwd: Practice

2010-10-30 Thread neil johnson

Hi Dave

Thanks a lot for giving solution .


On Wed, Oct 27, 2010 at 2:31 AM, Sergio Abadesso <
groups.abade...@googlemail.com> wrote:

> Hi Dave,
>
> you have to consider that the property object.List(row, column) has two
> arguments. The first argument is to pass the row number and the second is to
> pass the column number.
> Check the file.
>
> I hope I could help you.
>
> cheers
> Sergio
>
> 2010/10/26 neil johnson 
>
>>
>> Hi Everyone,
>>
>> I need your help. I make listbox using user form in excel . in listbox
>> there is data from sheet 3 . now i transfer selected data to sheet 2 . it is
>> working but not in proper manner . when i select data it shows data  in cell
>> A range not completely . Please help me
>>
>> 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/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
>

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

$$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA for Church Project

2010-10-30 Thread MT

Hello. I have (2) worksheets in my Excel Workbook; "Offering" and
"General Check Continuation". Could someone please help me with the
code to be able to print the work sheet "Offering" and also worksheet
"General Check Continuation" only if cell I36 on "General Check
Continuation" is greater than 0 otherwise I need
it to just print the worksheet "Offering". Thank you Much!

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

2010-10-30 Thread Daniel

Use :

At the beginning of the macro :

 

Dim inCalculationMode As Integer

inCalculationMode = Application.Calculation

Application.Calculation = xlCalculationManual

 

At the end of the macro :

 

Application.Calculation = inCalculationMode

 

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de vamsi varma
Envoyé : vendredi 29 octobre 2010 21:39
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Screen updating

 

hi guys...

macros what i am using takes lot of time.

to reduce time i m using application.screenupdating=false at the begin

and made it true at the end..

it is working in some macros. 

but in some macros it is nt working... i am nt able to find the reason..

any one can help to sort this issue..

-- 

--
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$$ Re: Help Required!

$$Excel-Macros$$ guide line in excell

Re: $$Excel-Macros$$ Macro to Go From One Cell to Another

Re: $$Excel-Macros$$ finding the last row

Re: $$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA for Church Project

Re: $$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA for Church Project

$$Excel-Macros$$ Macro to Go From One Cell to Another

Re: $$Excel-Macros$$ manage lengthy database

RE: $$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA for Church Project

Re: $$Excel-Macros$$ manage lengthy database

Re: $$Excel-Macros$$ Parsing a range to an array

$$Excel-Macros$$ finding the last row

$$Excel-Macros$$ VBA Controls are missing for some users

Re: $$Excel-Macros$$ Re: Help Required!

Re: $$Excel-Macros$$ Fwd: Practice

Re: $$Excel-Macros$$ Fwd: Practice

$$Excel-Macros$$ Novice Needs Help with Basic Excel Print Macro/VBA for Church Project

RE: $$Excel-Macros$$ Screen updating

18 matches

Site Navigation

Mail list logo

Footer information