Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

[Venkat CV]

Hi ,

See Below Links...
http://www.contextures.com/xlcondformat03.html\
http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *
*
*

On Wed, Sep 7, 2011 at 1:30 PM, zp18  wrote:

> A1=the name of an employee, defined name is "Suspect"
> A2= an amount of money, defined as "MaxLoss"
> B1:B8 is a column of money defined as "Shortages"
> C1:G8 is a range of employee names defined as "Associates"
>
>
> if the money contained in MaxLoss is less than the amount in column of
> Shortages and the "Suspect"'s name is contained in the Associates
> range then do something(bold, red, flashing etc)
>
>
> The intent is to match an employees name to shortages using
> conditional formatting
>
> James$57.20 Grace   Ronnie  MernalynIrene   0
> -50  $4.91  Julie   Jocelyn Tiffany
> RyanMark
> $22.50 Grace   Ronnie  James   Irene   Mernalyn
> $(0.78)Julie   Tiffany RyanMark
>0
> $50.06 Grace   James   MernalynIrene   0
> $2.65  Julie   Tiffany RyanMark0
> $24.28 Grace   0  00
> 0
> $(373.20)  Julie   Jocelyn Ryan0
> 0
>
> What should the statement be?  I cannot get the hang of logical
> operators in conditional formatting, any help would be appreciated.
>
> TIA
>
> --
>
> --
> 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$$ How to recast a variant as an array in VBA

[Venkat CV]

Hi,

See below links..

http://www.mrexcel.com/forum/showthread.php?t=32187
http://www.ozgrid.com/forum/showthread.php?t=69235&page=1
http://www.cpearson.com/excel/vbaarrays.htm

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *

On Wed, Sep 7, 2011 at 3:56 PM, ShayneH  wrote:

> Is there a way to expose an array that is enclosed by a variant?
> Basically I have one function that returns a variant type which needs
> to be passed to another procedure that requires the parameter to be
> typed as a byte array.
>
> eg:
> Function UsuallyReturnsAnArray() As Variant
>
> the result, after testing to be an array is passed to:
>
> Sub ConsumesByteArray(ByRef ByteArray() As Byte)
>
> I need to find a way to coerce the variant that contains a byte array
> returned from the first function to a byte array.
> Copying each element to a dimensioned array is a possible solution,
> but it seems to me there must be a way to reference the array that is
> contained inside the variant type.
>
> Thanks in advance
>
> --
>
> --
> 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$$ Re: blink the Label caption

[Deepak Pal Singh]

It won't work... Just want to confirm whether do you want to blink your text
in a label or in cells...??

Regards
Deepak

On Wed, Sep 7, 2011 at 7:30 PM, Bheema Shankar wrote:

> Deepak ji
>
> I made little changes to your code to blink my label caption on the
> form:
>
>
> Dim MyArray() As Variant
> Dim i As Integer, R As Long, C As Integer
> Dim vText As String
> Dim DelayLoop1 As Long, DelayLoop2 As Long
> Sub StartBlinking()
> vText = Label1.Caption
> For i = 1 To Len(vText)
>ReDim Preserve MyArray(1 To i)
>MyArray(i) = Right(Left(vText, i), 1)
> Next i
> For R = 1 To UBound(MyArray)
>For DelayLoop1 = 1 To 2000
>Next DelayLoop1
>For i = 3 To 20 - R + 1
> Label1.Caption = MyArray(R)
>
>For DelayLoop2 = 1 To 2000
>Next DelayLoop2
>Next i
>'Range("D3:D" & 20 - R).ClearContents
> Next R
> For R = 1 To UBound(MyArray)
>For DelayLoop1 = 1 To 2000
>Next DelayLoop1
>For i = 20 To 3 + R - 1 Step -1
> Label1.Caption = MyArray(R)
>
>For DelayLoop2 = 1 To 2000
>Next DelayLoop2
>Next i
>'Range("D" & 3 + R & ":D20").ClearContents
> Next R
> End Sub
>
>
> Dont understand where I did wrong.  its not working
>
> On Sep 7, 5:42 pm, deepu  wrote:
> > Though MS-Excel is not an application where you can make high class
> > animation.. but it depends on your creativity.. how do you utilize
> > your knowledge to bring such an effects in Excel.. Below is the code
> > that I've create, you can modify it according to your requirements,
> > you might want to change formatting of the cells... Just paste this
> > code in a module and run it..
> >
> >
> ---
> ---
> ---
> >
> > Dim MyArray() As Variant
> > Dim  i As Integer, R As Long, C As Integer
> > Dim vText As String
> > Dim DelayLoop1 As Long, DelayLoop2 As Long
> >
> > Sub StartBlinking()
> >
> > vText = InputBox("Enter Any Text Upto Than 10 Chars", "Text Required")
> > For i = 1 To Len(vText)
> > ReDim Preserve MyArray(1 To i)
> > MyArray(i) = Right(Left(vText, i), 1)
> > Next i
> > For R = 1 To UBound(MyArray)
> > For DelayLoop1 = 1 To 2000
> > Next DelayLoop1
> > For i = 3 To 20 - R + 1
> > Range("D" & i).Value = MyArray(R)
> > Range("D" & i).HorizontalAlignment = xlCenter
> > Range("D" & i).Font.Size =
> > Application.WorksheetFunction.RandBetween(7, 25)
> > Range("D" & i).Font.Color =
> > RGB(Application.WorksheetFunction.RandBetween(20, 149),
> > Application.WorksheetFunction.RandBetween(20, 149),
> > Application.WorksheetFunction.RandBetween(20, 149))
> > For DelayLoop2 = 1 To 2000
> > Next DelayLoop2
> > Next i
> > Range("D3:D" & 20 - R).ClearContents
> > Next R
> >
> > For R = 1 To UBound(MyArray)
> > For DelayLoop1 = 1 To 2000
> > Next DelayLoop1
> > For i = 20 To 3 + R - 1 Step -1
> > Range("D" & i).Value = MyArray(R)
> > Range("D" & i).HorizontalAlignment = xlCenter
> > Range("D" & i).Font.Size =
> > Application.WorksheetFunction.RandBetween(7, 25)
> > Range("D" & i).Font.Color =
> > RGB(Application.WorksheetFunction.RandBetween(20, 149),
> > Application.WorksheetFunction.RandBetween(20, 149),
> > Application.WorksheetFunction.RandBetween(20, 149))
> > For DelayLoop2 = 1 To 2000
> > Next DelayLoop2
> > Next i
> > Range("D" & 3 + R & ":D20").ClearContents
> > Next R
> >
> > End Sub
> >
> >
> ---
> ---
> -
> >
> > Regards
> > Deepak
> >
> > On Sep 7, 1:51 pm, Bheema Shankar  wrote:
> >
> >
> >
> >
> >
> >
> >
> > > Pls provide code for BLINK affect for Label caption.
>
> --
>
> --
> 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.blogsp

Re: $$Excel-Macros$$ Add the multiple row values & delete the duplicate row

[anu gomathi]

Hi Noorain,

Opportunity column contains the duplicate. I need to convert the rows in to
unique by adding the values.

Regards

Anu

On Thu, Sep 8, 2011 at 10:37 AM, NOORAIN ANSARI wrote:

> Hi anu,
>
> Please explain the criteria of duplicacy.
> Like another row should be same campare to first row.
>
>   On Thu, Sep 8, 2011 at 10:21 AM, anu gomathi 
> wrote:
>
>> Hi Experts,
>>
>> Need your help in this.
>>
>> Regards
>>
>> Anu
>>
>>   On Wed, Sep 7, 2011 at 11:37 PM, anu gomathi > > wrote:
>>
>>> Hi All,
>>>
>>> Attached the sample file with the duplicate opportunity details. I need
>>> to add the values in the 1 row & delete the duplicate rows.
>>>
>>> Need u r help to create macros.
>>>
>>> Regards
>>>
>>> Anu
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> --
>
> --
> 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$$ Add the multiple row values & delete the duplicate row

[NOORAIN ANSARI]

Hi anu,

Please explain the criteria of duplicacy.
Like another row should be same campare to first row.

On Thu, Sep 8, 2011 at 10:21 AM, anu gomathi wrote:

> Hi Experts,
>
> Need your help in this.
>
> Regards
>
> Anu
>
>   On Wed, Sep 7, 2011 at 11:37 PM, anu gomathi 
> wrote:
>
>> Hi All,
>>
>> Attached the sample file with the duplicate opportunity details. I need to
>> add the values in the 1 row & delete the duplicate rows.
>>
>> Need u r help to create macros.
>>
>> Regards
>>
>> Anu
>>
>> --
>>
>> --
>> 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
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
--
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$$ Add the multiple row values & delete the duplicate row

[anu gomathi]

Hi Experts,

Need your help in this.

Regards

Anu

On Wed, Sep 7, 2011 at 11:37 PM, anu gomathi wrote:

> Hi All,
>
> Attached the sample file with the duplicate opportunity details. I need to
> add the values in the 1 row & delete the duplicate rows.
>
> Need u r help to create macros.
>
> Regards
>
> Anu
>
> --
>
> --
> 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

$$Excel-Macros$$ Report Generation

[Shankar Bheema]

What is the procedure to develop reports basing on the excel database
through UserForm.

Report generation in the sense, not in column and rows.

It would be look like a form in word document.

-- 
--
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$$ problem with cell width in a workbook

[Shankar Bheema]

good morning Noorain

I tried with your example sheet.  But it is fitting the cell width just like
the Format-->Autofit option in the excel.  But what I need is,

the particular cells containing the red font has to be fit to their text
width and the following column width may left as they are.

suppose

d10 is having 2 characters
d15 is having 34 characters

both should fit to their textwidths without disturbing the remaining cell
widths in the same column.

On Wed, Sep 7, 2011 at 6:40 PM, Shankar Bheema wrote:

> I am not getting even after selection as you said.  I noticed non of the
> control is allowing to work on the sheet what would be the prblem with my
> excel ?
>
> On Wed, Sep 7, 2011 at 6:31 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Bheema,
>>
>> First of all you select a range when you want to apply it...
>> it work after selection...
>>
>> you select red font area then press it..
>> Hope it will work fine..
>>
>> On Wed, Sep 7, 2011 at 6:24 PM, Shankar Bheema wrote:
>>
>>> I downloaded your file but unable to click on the command button as I
>>> placed my cursor on the command button it is turning into 4 headed arrow and
>>> clicking is not possible.  what to do ?
>>>
>>>   On Tue, Sep 6, 2011 at 11:02 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
   Dear Bheema,

 Please try it and see attached sheet

 Sub Autofit()
  If TypeName(Selection) = "Range" Then
 Selection.Columns.Autofit
 End If
  End Sub



 Thanks & regards,
 Noorain Ansari
  
 *http://excelmacroworld.blogspot.com/*
 *http://noorain-ansari.blogspot.com/*
  On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema >>> > wrote:

> sure guruji, pls have a look at my attachment and provide me solution.
>
>  I marked the cell data with Redcolor.  Those are to be adjusted to
> their width and remaining to their respective widths.  Kindly provide
> solution.
>
>   On Tue, Sep 6, 2011 at 7:06 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>>   Dear Bheema,
>>
>> please share attachement with any rough example..
>>
>> --
>>
>> On Tue, Sep 6, 2011 at 6:56 PM, Bheema Shankar <
>> shankar.n...@gmail.com> wrote:
>>
>>> Pls.  I need a form to adjust to the data widths of different sizes.
>>> Its  a part of the form basing on your solution I have to prepare
>>> that
>>> form of 3 pages.  pls provide solution.
>>>
>>> --
>>>
>>> --
>>> 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.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/disc

Re: $$Excel-Macros$$ PDF to Excel

[Prabhu]

On Thu, Sep 8, 2011 at 9:17 AM, Prabhu  wrote:

> Hi Ahsish,
>
>
> Now Debug highlighted the below line.
>

 "Subscript out of range"

>
> Windows("pdf to excel.xlsm").Activate
>
>
> *Adobe reader X shows "There was an error opening this documents.Access
> denied.*
>
>
> On Thu, Sep 8, 2011 at 8:09 AM, ashish koul  wrote:
>
>> Also change path of winzip
>>
>> a = "C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe"
>>
>>
>>
>>
>>
>> On Wed, Sep 7, 2011 at 9:20 PM, Prabhu  wrote:
>>
>>> HI Ashish,
>>>
>>> I have changed the PDF file path address, apart from this change i have
>>> to any changes?
>>>
>>> Because i am getting run time error. Debug highlighted the below line.
>>>
>>> c = Shell("" & a & " " & b & "", 1)
>>>
>>> --
>>>
>>> --
>>> 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 
>> http://akoul.posterous.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
>>
>
>

-- 
--
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$$ PDF to Excel

[Prabhu]

Hi Ahsish,


Now Debug highlighted the below line.

Windows("pdf to excel.xlsm").Activate


*Adobe reader X shows "There was an error opening this documents.Access
denied.*


On Thu, Sep 8, 2011 at 8:09 AM, ashish koul  wrote:

> Also change path of winzip
>
> a = "C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe"
>
>
>
>
>
> On Wed, Sep 7, 2011 at 9:20 PM, Prabhu  wrote:
>
>> HI Ashish,
>>
>> I have changed the PDF file path address, apart from this change i have to
>> any changes?
>>
>> Because i am getting run time error. Debug highlighted the below line.
>>
>> c = Shell("" & a & " " & b & "", 1)
>>
>> --
>>
>> --
>> 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 
> http://akoul.posterous.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
>

-- 
--
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$$ How to develop a query for excel table

[sagaraher]

@ Tariq & XLS S..

I will also required all details in next line for input given by me..

E.g If for supplier no. 'X' & Buiness Role 'Y'..if ther are 3-4
contacts details available then I should get all 3-4 contact details
against input given by me..it should fetch all details related to
input n not only 1..

pl reply back for any further info..

thanks

On Sep 8, 12:32 am, XLS S  wrote:
> Hey,
>
> Please find the attachment.
>
>
>
>
>
> On Wed, Sep 7, 2011 at 1:55 PM, Sagar Aher  wrote:
> > Hello,
>
> > I'm looking for query development in spreadsheet.
>
> > Pl find attachement.
>
> > My Requirement
>
> > 1) Select Supplier No.
> > 2) Select Buiness Role
>
> > Then I should get data as Supplier Name, All Name against that buiness role
>
> > Plz help.
>
> > --
>
> > ---­---
> > 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
>
> --
> .
>
>  Copy of Excel Query-1.xlsx
> 241KViewDownload- 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

Re: $$Excel-Macros$$ PDF to Excel

[ashish koul]

Also change path of winzip

a = "C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe"





On Wed, Sep 7, 2011 at 9:20 PM, Prabhu  wrote:

> HI Ashish,
>
> I have changed the PDF file path address, apart from this change i have to
> any changes?
>
> Because i am getting run time error. Debug highlighted the below line.
>
> c = Shell("" & a & " " & b & "", 1)
>
> --
>
> --
> 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 
http://akoul.posterous.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$$ Macro to Copy the sheets from One file to Multiple Files

[ashish koul]

Hi,

Sub test()
For i = 1 To 10
ThisWorkbook.Sheets(Array("Sheet1", "Sheet2")).Copy
ActiveWorkbook.SaveAs "C:\Documents and Settings\ASHISH\Desktop\ABC\book" &
i & ".xlsx"
ActiveWorkbook.Close
Next i

End Sub


On Wed, Sep 7, 2011 at 5:29 PM, SridharBL  wrote:

> Ashish,
>
> I need to save the sheets of One Workbook to 12 other workbooks.
>
>
> Say, I have One Master excel work book with sheets x and y. These x and y
> sheets should be moved to other 12 workbooks.
>
> So, now all the 12 Work books will have x & y sheets as of Master excel
> work book.
>
> Thanks,
> Sridhar BL
>
> --
>
> --
> 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 
http://akoul.posterous.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$$ rounding to next higher rupee

[Shankar Bheema]

ya its working. amazing. thank you so much

On Wed, Sep 7, 2011 at 9:48 PM, NOORAIN ANSARI wrote:

> see if it help
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Wed, Sep 7, 2011 at 7:22 PM, Shankar Bheema wrote:
>
>> I am attaching an excel file with inserted userform.
>>
>> I have given command button to roundoff the figure in textbox1.text to the
>> next higher rupee.  I have given the code as
>>
>> textbox2.text=Round(val(textbox1.text),0)
>>
>> but its returning wrong result.
>>
>> if i have given 100.1 in textbox1.text
>>
>> the result should be 102 in textbox2.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
>

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

[Shankar Bheema]

Its ok saber

On Wed, Sep 7, 2011 at 8:05 PM, mohd saber  wrote:

> Hi Shankar,
>
> Sorry to say that as far as i know there is no way
>
> regards,
> saber
>
> On Wed, Sep 7, 2011 at 8:02 PM, Shankar Bheema wrote:
>
>> means sir,   is there no way to do like Visual basic with VBA excel ?
>>
>>
>> On Wed, Sep 7, 2011 at 7:46 PM, mohd saber wrote:
>>
>>> Hi Shankar,
>>>
>>> As far as i understand is that you want only the userform not the excel
>>> workbook.
>>> If this is the case you need to use VISUAL BASIC for preparing the form
>>> not vba which is inbuilt in any application.
>>> Please let me know if you need any clarification.
>>>
>>> Regards,
>>> saber
>>>
>>>   On Wed, Sep 7, 2011 at 6:47 PM, Shankar Bheema >> > wrote:
>>>
 Hai all

 What I have a problem is,  I made an userform with all controls.  But it
 wont be directly accessed without opening the excel form..

 Pls suggest me a way to access directly the userform without opening the
 Excel sheet.

 --

 --
 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,
>>> Saber
>>>
>>> --
>>>
>>> --
>>> 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,
> Saber
>
>  --
>
> --
> 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$$ code for search

[Shankar Bheema]

how to place grid control in vba excel ?

On Wed, Sep 7, 2011 at 8:04 PM, dguillett1  wrote:

>   I’m one of those people who  doesn’t much care for pivot tables and
> userforms. KISS (Keep it simple, stupid). Not meant personally.
>
>  *From:* Shankar Bheema 
> *Sent:* Wednesday, September 07, 2011 9:04 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ code for search
>
> not working. and where to put this code.  I made it on userform not on
> sheet.  So in your formula there is no representation of the objects na. how
> it works ?
>
> On Wed, Sep 7, 2011 at 7:20 PM, dguillett1  wrote:
>
>>   How about a formula
>>
>> =INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
>>
>>  *From:* Shankar Bheema 
>> *Sent:* Wednesday, September 07, 2011 8:14 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ code for search
>>
>>   Hai all good evening
>>
>> I am attaching the excel sheet which contains file numbers and names in
>> corresponding file number.  I placed an userform with file no. and name with
>> a command button for search.
>>
>> If we know the name and dont know the file no. by giving little part of
>> the name and if pressed on the search button it should show the file number
>> and
>>
>> if we know the file number and dont know the name by giving the file
>> number on the corresponding textbox and pressing the button it should return
>> the name of the employee
>>
>> pls suggest me the code
>> --
>>
>> --
>> 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.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.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$$ problem with duplication of data

[Shankar Bheema]

thank you so much saber

On Wed, Sep 7, 2011 at 8:03 PM, mohd saber  wrote:

> Hi Shankar,
>
> Please find the below updated data for the command file
>
> Private Sub CommandButton1_Click()
> ActiveWorkbook.Sheets("Employee Details").Activate
> Range("A1").Select
> Do
>
>If IsEmpty(ActiveCell) = False Then
>  If activecell.value = txtfileno.value Then
>  ActiveCell.Offset(0, 1) = txtname.Text
> EndIf
>ActiveCell.Offset(1, 0).Select
> End If
> Loop Until IsEmpty(ActiveCell) = True
> ActiveCell.Value = txtfileno.Value
> ActiveCell.Offset(0, 1) = txtname.Text
> Regards,
> saber
> On Wed, Sep 7, 2011 at 6:58 PM, Bheema Shankar wrote:
>
>> I placed the following objects on my VBA excel
>>
>> TextBoxes
>> a) file no
>> b) Name
>>
>> Command buttons
>> a) Save
>> b) Update
>>
>> In save button I have given code as@@@
>>
>> Private Sub CommandButton1_Click()
>> ActiveWorkbook.Sheets("Employee Details").Activate
>> Range("A1").Select
>> Do
>>If IsEmpty(ActiveCell) = False Then
>>ActiveCell.Offset(1, 0).Select
>> End If
>>
>> Loop Until IsEmpty(ActiveCell) = True
>> ActiveCell.Value = txtfileno.Value
>> ActiveCell.Offset(0, 1) = txtname.Text
>>
>> In Update button i have given the code as @@@
>>
>> Dim ws As Worksheet
>> Dim uf As UserForm
>> Dim wslastrw As Long, filerow As Long
>> Dim fileno As String
>> Dim filefnd As Range
>>
>> Set uf = formcalsheet
>>
>> fileno = uf.txtfileno.Text
>>
>>If fileno = "" Then
>>MsgBox "Please enter a valid File No."
>>Exit Sub
>>End If
>>
>> Set ws = Worksheets("Employee Details")
>> wslastrw = ws.Range("A" & Rows.Count).End(xlUp).Row
>>
>> With ws
>>
>>  Set filefnd = .Range("A2:A" & wslastrw).Find(what:=fileno,
>> after:=.Range("A2"), _
>>LookIn:=xlValues, lookat:=xlPart, searchorder:=xlByRows,
>> searchdirection:=xlNext, _
>>MatchCase:=False)
>>If filefnd Is Nothing Then
>>MsgBox "No File with this File No. exists." & Chr(10) &
>> "Please enter a valid File No."
>>Exit Sub
>>Else
>>filerow = filefnd.Row
>>End If
>>
>> uf.txtname.Value = ws.Range("B" & filerow).Value
>>
>>
>>
>> PROBLEM IS#
>>
>> while clicking the update button after giving the file number the form
>> will present the corresponding data to that particular number
>>
>> If I modify any change and clicks the save button again a fresh row is
>> creating with the same number
>>
>>
>> It should be avoided.  The data should be amended in the existing row
>> itself.  whats wrong with the code. provide me solution
>>
>> --
>>
>> --
>> 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,
> Saber
>
>  --
>
> --
> 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$$ Reasons for increase in excel file size

[XLS S]

Hey Amit,

Try this

*Method 1:*

   1. Open the Excel file
   2. Then save the Excel file in html format
   3. Then save the html document into xls but as another name

*For spreadsheets with only text:*

*Method 2:*

   1. Open the Excel file
   2. Save the Excel file as xml format
   3. Save the Excel file as xls format but as another name



On Wed, Sep 7, 2011 at 10:46 AM, Amit Desai (MERU)
wrote:

>  What could be the reason for increase in excel file? I have a file with
> size of 4.5 MB, but data contents are not that much.
>
> ** **
>
> Best Regards,
>
> Amit Desai
>
> ** **
>
> ** **
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
>
> --
> 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$$ Conditional Formatting Excel 2007

[XLS S]

Hey ,

Please send the attachment...

try the below link

http://www.contextures.com/xlcondformat02.html
http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel

On Wed, Sep 7, 2011 at 1:30 PM, zp18  wrote:

> A1=the name of an employee, defined name is "Suspect"
> A2= an amount of money, defined as "MaxLoss"
> B1:B8 is a column of money defined as "Shortages"
> C1:G8 is a range of employee names defined as "Associates"
>
>
> if the money contained in MaxLoss is less than the amount in column of
> Shortages and the "Suspect"'s name is contained in the Associates
> range then do something(bold, red, flashing etc)
>
>
> The intent is to match an employees name to shortages using
> conditional formatting
>
> James$57.20 Grace   Ronnie  MernalynIrene   0
> -50  $4.91  Julie   Jocelyn Tiffany
> RyanMark
> $22.50 Grace   Ronnie  James   Irene   Mernalyn
> $(0.78)Julie   Tiffany RyanMark
>0
> $50.06 Grace   James   MernalynIrene   0
> $2.65  Julie   Tiffany RyanMark0
> $24.28 Grace   0  00
> 0
> $(373.20)  Julie   Jocelyn Ryan0
> 0
>
> What should the statement be?  I cannot get the hang of logical
> operators in conditional formatting, any help would be appreciated.
>
> TIA
>
> --
>
> --
> 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

$$Excel-Macros$$ Add the multiple row values & delete the duplicate row

[anu gomathi]

Hi All,

Attached the sample file with the duplicate opportunity details. I need to
add the values in the 1 row & delete the duplicate rows.

Need u r help to create macros.

Regards

Anu

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


Pipe Details.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ rounding to next higher rupee

[NOORAIN ANSARI]

see if it help
-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

On Wed, Sep 7, 2011 at 7:22 PM, Shankar Bheema wrote:

> I am attaching an excel file with inserted userform.
>
> I have given command button to roundoff the figure in textbox1.text to the
> next higher rupee.  I have given the code as
>
> textbox2.text=Round(val(textbox1.text),0)
>
> but its returning wrong result.
>
> if i have given 100.1 in textbox1.text
>
> the result should be 102 in textbox2.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


Application.worksheetfunction.Roundup.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need some help in transposing data

[NOORAIN ANSARI]

Dear Nishant,

Please see attached sheet..


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

On Wed, Sep 7, 2011 at 5:15 PM, Nishant Singla  wrote:

>
> Hello Friends ...
>
> I have attached the file above I have the data in this form given in the
> attached file ...
>
> I need to convert it into the format given in the attached file ...
>
> Kindly help me ASAP ...
>
> Regards
>
> Nishant Singla
>
> Mobile : 9910329711 , 9463087506
>
> --
>
> --
> 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


ProblemExcelTranspose(solved).xlsm
Description: Binary data

RE: $$Excel-Macros$$ rounding to next higher rupee

[Daniel]

Private Sub CommandButton1_Click()

TextBox2.Text = Application.RoundUp(Val(TextBox1.Text), 0)

End Sub

 

100.1 results to be 101.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Shankar Bheema
Envoyé : mercredi 7 septembre 2011 15:52
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ rounding to next higher rupee

 

I am attaching an excel file with inserted userform.

 

I have given command button to roundoff the figure in textbox1.text to the
next higher rupee.  I have given the code as

 

textbox2.text=Round(val(textbox1.text),0)

 

but its returning wrong result.

 

if i have given 100.1 in textbox1.text

 

the result should be 102 in textbox2.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$$ PDF to Excel

[Prabhu]

HI Ashish,

I have changed the PDF file path address, apart from this change i have to 
any changes?

Because i am getting run time error. Debug highlighted the below line.

c = Shell("" & a & " " & b & "", 1)

-- 
--
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$$ Decrease the gap between bars in Bar Chart

[dguillett1]

Change the AXES to category. You don’t say which version but in 2003 right 
click the chart and select 


From: Ramanjaneya Reddy 
Sent: Tuesday, September 06, 2011 10:45 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Decrease the gap between bars in Bar Chart

Is there any way to decrease the gap between bars (NOT the width of the bars) 
of excel bar chart?
I made a bar chart with 23 dates (weeks like 10/5/2007, 10/12/2007, 10/19/2007 
etc.). The row were very thin and the gap between the rows is long. Can we 
decrease the gap between the bars to make it look good?

Thanks in advance...

Regards,
Ramanjaneya
-- 
--
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$$ VBA Doubt

[mohd saber]

Hi Shankar,

Sorry to say that as far as i know there is no way

regards,
saber

On Wed, Sep 7, 2011 at 8:02 PM, Shankar Bheema wrote:

> means sir,   is there no way to do like Visual basic with VBA excel ?
>
>
> On Wed, Sep 7, 2011 at 7:46 PM, mohd saber  wrote:
>
>> Hi Shankar,
>>
>> As far as i understand is that you want only the userform not the excel
>> workbook.
>> If this is the case you need to use VISUAL BASIC for preparing the form
>> not vba which is inbuilt in any application.
>> Please let me know if you need any clarification.
>>
>> Regards,
>> saber
>>
>>   On Wed, Sep 7, 2011 at 6:47 PM, Shankar Bheema 
>> wrote:
>>
>>> Hai all
>>>
>>> What I have a problem is,  I made an userform with all controls.  But it
>>> wont be directly accessed without opening the excel form..
>>>
>>> Pls suggest me a way to access directly the userform without opening the
>>> Excel sheet.
>>>
>>> --
>>>
>>> --
>>> 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,
>> Saber
>>
>> --
>>
>> --
>> 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,
Saber

-- 
--
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$$ code for search

[dguillett1]

I’m one of those people who  doesn’t much care for pivot tables and userforms. 
KISS (Keep it simple, stupid). Not meant personally.

From: Shankar Bheema 
Sent: Wednesday, September 07, 2011 9:04 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ code for search

not working. and where to put this code.  I made it on userform not on sheet.  
So in your formula there is no representation of the objects na. how it works ?


On Wed, Sep 7, 2011 at 7:20 PM, dguillett1  wrote:

  How about a formula

=INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
 


  From: Shankar Bheema 
  Sent: Wednesday, September 07, 2011 8:14 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ code for search

  Hai all good evening

  I am attaching the excel sheet which contains file numbers and names in 
corresponding file number.  I placed an userform with file no. and name with a 
command button for search.   

  If we know the name and dont know the file no. by giving little part of the 
name and if pressed on the search button it should show the file number and 

  if we know the file number and dont know the name by giving the file number 
on the corresponding textbox and pressing the button it should return the name 
of the employee

  pls suggest me the code
  -- 
  
--
  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.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$$ problem with duplication of data

[mohd saber]

Hi Shankar,

Please find the below updated data for the command file

Private Sub CommandButton1_Click()
ActiveWorkbook.Sheets("Employee Details").Activate
Range("A1").Select
Do

   If IsEmpty(ActiveCell) = False Then
 If activecell.value = txtfileno.value Then
 ActiveCell.Offset(0, 1) = txtname.Text
EndIf
   ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
ActiveCell.Value = txtfileno.Value
ActiveCell.Offset(0, 1) = txtname.Text
Regards,
saber
On Wed, Sep 7, 2011 at 6:58 PM, Bheema Shankar wrote:

> I placed the following objects on my VBA excel
>
> TextBoxes
> a) file no
> b) Name
>
> Command buttons
> a) Save
> b) Update
>
> In save button I have given code as@@@
>
> Private Sub CommandButton1_Click()
> ActiveWorkbook.Sheets("Employee Details").Activate
> Range("A1").Select
> Do
>If IsEmpty(ActiveCell) = False Then
>ActiveCell.Offset(1, 0).Select
> End If
>
> Loop Until IsEmpty(ActiveCell) = True
> ActiveCell.Value = txtfileno.Value
> ActiveCell.Offset(0, 1) = txtname.Text
>
> In Update button i have given the code as @@@
>
> Dim ws As Worksheet
> Dim uf As UserForm
> Dim wslastrw As Long, filerow As Long
> Dim fileno As String
> Dim filefnd As Range
>
> Set uf = formcalsheet
>
> fileno = uf.txtfileno.Text
>
>If fileno = "" Then
>MsgBox "Please enter a valid File No."
>Exit Sub
>End If
>
> Set ws = Worksheets("Employee Details")
> wslastrw = ws.Range("A" & Rows.Count).End(xlUp).Row
>
> With ws
>
>  Set filefnd = .Range("A2:A" & wslastrw).Find(what:=fileno,
> after:=.Range("A2"), _
>LookIn:=xlValues, lookat:=xlPart, searchorder:=xlByRows,
> searchdirection:=xlNext, _
>MatchCase:=False)
>If filefnd Is Nothing Then
>MsgBox "No File with this File No. exists." & Chr(10) &
> "Please enter a valid File No."
>Exit Sub
>Else
>filerow = filefnd.Row
>End If
>
> uf.txtname.Value = ws.Range("B" & filerow).Value
>
>
>
> PROBLEM IS#
>
> while clicking the update button after giving the file number the form
> will present the corresponding data to that particular number
>
> If I modify any change and clicks the save button again a fresh row is
> creating with the same number
>
>
> It should be avoided.  The data should be amended in the existing row
> itself.  whats wrong with the code. provide me solution
>
> --
>
> --
> 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,
Saber

-- 
--
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$$ Re: rounding to next higher rupee

[Shankar Bheema]

thank you so much sam

On Wed, Sep 7, 2011 at 7:47 PM, GoldenLance  wrote:

> TextBox2.Text = Application.RoundUp(Val(TextBox1.Text), 0)
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
> On Sep 7, 6:52 pm, Shankar Bheema  wrote:
> > I am attaching an excel file with inserted userform.
> >
> > I have given command button to roundoff the figure in textbox1.text to
> the
> > next higher rupee.  I have given the code as
> >
> > textbox2.text=Round(val(textbox1.text),0)
> >
> > but its returning wrong result.
> >
> > if i have given 100.1 in textbox1.text
> >
> > the result should be 102 in textbox2.text
> >
> >  rounding doubt.xls
> > 33KViewDownload
>
> --
>
> --
> 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$$ VBA Doubt

[Shankar Bheema]

means sir,   is there no way to do like Visual basic with VBA excel ?

On Wed, Sep 7, 2011 at 7:46 PM, mohd saber  wrote:

> Hi Shankar,
>
> As far as i understand is that you want only the userform not the excel
> workbook.
> If this is the case you need to use VISUAL BASIC for preparing the form not
> vba which is inbuilt in any application.
> Please let me know if you need any clarification.
>
> Regards,
> saber
>
> On Wed, Sep 7, 2011 at 6:47 PM, Shankar Bheema wrote:
>
>> Hai all
>>
>> What I have a problem is,  I made an userform with all controls.  But it
>> wont be directly accessed without opening the excel form..
>>
>> Pls suggest me a way to access directly the userform without opening the
>> Excel sheet.
>>
>> --
>>
>> --
>> 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,
> Saber
>
>  --
>
> --
> 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

$$Excel-Macros$$ Re: How to recast a variant as an array in VBA

[GoldenLance]

You cannot reference a variant array using a byte array even if the
data contained within the variant array is all byte.

Suggest using Sub ConsumesByteArray(ByRef ByteArray)

On Sep 7, 3:26 pm, ShayneH  wrote:
> Is there a way to expose an array that is enclosed by a variant?
> Basically I have one function that returns a variant type which needs
> to be passed to another procedure that requires the parameter to be
> typed as a byte array.
>
> eg:
> Function UsuallyReturnsAnArray() As Variant
>
> the result, after testing to be an array is passed to:
>
> Sub ConsumesByteArray(ByRef ByteArray() As Byte)
>
> I need to find a way to coerce the variant that contains a byte array
> returned from the first function to a byte array.
> Copying each element to a dimensioned array is a possible solution,
> but it seems to me there must be a way to reference the array that is
> contained inside the variant type.
>
> Thanks in advance

-- 
--
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$$ Re: VBA Doubt

[Shankar Bheema]

I attached the workbook

On Wed, Sep 7, 2011 at 7:41 PM, deepu  wrote:

> Can you please elaborate?? What exactly you want to do..?? It'll be
> helpful if you can provide any demo workbook..
>
> Regards
> Deepak
>
> On Sep 7, 6:17 pm, Shankar Bheema  wrote:
> > Hai all
> >
> > What I have a problem is,  I made an userform with all controls.  But it
> > wont be directly accessed without opening the excel form..
> >
> > Pls suggest me a way to access directly the userform without opening the
> > Excel sheet.
>
> --
>
> --
> 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


blink me.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: rounding to next higher rupee

[GoldenLance]

TextBox2.Text = Application.RoundUp(Val(TextBox1.Text), 0)

Regards,

Sam Mathai Chacko (GL)

On Sep 7, 6:52 pm, Shankar Bheema  wrote:
> I am attaching an excel file with inserted userform.
>
> I have given command button to roundoff the figure in textbox1.text to the
> next higher rupee.  I have given the code as
>
> textbox2.text=Round(val(textbox1.text),0)
>
> but its returning wrong result.
>
> if i have given 100.1 in textbox1.text
>
> the result should be 102 in textbox2.text
>
>  rounding doubt.xls
> 33KViewDownload

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

[mohd saber]

Hi Shankar,

As far as i understand is that you want only the userform not the excel
workbook.
If this is the case you need to use VISUAL BASIC for preparing the form not
vba which is inbuilt in any application.
Please let me know if you need any clarification.

Regards,
saber

On Wed, Sep 7, 2011 at 6:47 PM, Shankar Bheema wrote:

> Hai all
>
> What I have a problem is,  I made an userform with all controls.  But it
> wont be directly accessed without opening the excel form..
>
> Pls suggest me a way to access directly the userform without opening the
> Excel sheet.
>
> --
>
> --
> 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,
Saber

-- 
--
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$$ Re: VBA Doubt

[deepu]

Can you please elaborate?? What exactly you want to do..?? It'll be
helpful if you can provide any demo workbook..

Regards
Deepak

On Sep 7, 6:17 pm, Shankar Bheema  wrote:
> Hai all
>
> What I have a problem is,  I made an userform with all controls.  But it
> wont be directly accessed without opening the excel form..
>
> Pls suggest me a way to access directly the userform without opening the
> Excel sheet.

-- 
--
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$$ code for search

[Shankar Bheema]

not working. and where to put this code.  I made it on userform not on
sheet.  So in your formula there is no representation of the objects na. how
it works ?

On Wed, Sep 7, 2011 at 7:20 PM, dguillett1  wrote:

>   How about a formula
>
> =INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
>
>  *From:* Shankar Bheema 
> *Sent:* Wednesday, September 07, 2011 8:14 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ code for search
>
>  Hai all good evening
>
> I am attaching the excel sheet which contains file numbers and names in
> corresponding file number.  I placed an userform with file no. and name with
> a command button for search.
>
> If we know the name and dont know the file no. by giving little part of the
> name and if pressed on the search button it should show the file number and
>
> if we know the file number and dont know the name by giving the file number
> on the corresponding textbox and pressing the button it should return the
> name of the employee
>
> pls suggest me the code
> --
>
> --
> 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.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$$ Re: blink the Label caption

[Bheema Shankar]

Deepak ji

I made little changes to your code to blink my label caption on the
form:


Dim MyArray() As Variant
Dim i As Integer, R As Long, C As Integer
Dim vText As String
Dim DelayLoop1 As Long, DelayLoop2 As Long
Sub StartBlinking()
vText = Label1.Caption
For i = 1 To Len(vText)
ReDim Preserve MyArray(1 To i)
MyArray(i) = Right(Left(vText, i), 1)
Next i
For R = 1 To UBound(MyArray)
For DelayLoop1 = 1 To 2000
Next DelayLoop1
For i = 3 To 20 - R + 1
Label1.Caption = MyArray(R)

For DelayLoop2 = 1 To 2000
Next DelayLoop2
Next i
'Range("D3:D" & 20 - R).ClearContents
Next R
For R = 1 To UBound(MyArray)
For DelayLoop1 = 1 To 2000
Next DelayLoop1
For i = 20 To 3 + R - 1 Step -1
Label1.Caption = MyArray(R)

For DelayLoop2 = 1 To 2000
Next DelayLoop2
Next i
'Range("D" & 3 + R & ":D20").ClearContents
Next R
End Sub


Dont understand where I did wrong.  its not working

On Sep 7, 5:42 pm, deepu  wrote:
> Though MS-Excel is not an application where you can make high class
> animation.. but it depends on your creativity.. how do you utilize
> your knowledge to bring such an effects in Excel.. Below is the code
> that I've create, you can modify it according to your requirements,
> you might want to change formatting of the cells... Just paste this
> code in a module and run it..
>
> --- 
> --- 
> ---
>
> Dim MyArray() As Variant
> Dim  i As Integer, R As Long, C As Integer
> Dim vText As String
> Dim DelayLoop1 As Long, DelayLoop2 As Long
>
> Sub StartBlinking()
>
> vText = InputBox("Enter Any Text Upto Than 10 Chars", "Text Required")
> For i = 1 To Len(vText)
>     ReDim Preserve MyArray(1 To i)
>     MyArray(i) = Right(Left(vText, i), 1)
> Next i
> For R = 1 To UBound(MyArray)
>     For DelayLoop1 = 1 To 2000
>     Next DelayLoop1
>     For i = 3 To 20 - R + 1
>         Range("D" & i).Value = MyArray(R)
>         Range("D" & i).HorizontalAlignment = xlCenter
>         Range("D" & i).Font.Size =
> Application.WorksheetFunction.RandBetween(7, 25)
>         Range("D" & i).Font.Color =
> RGB(Application.WorksheetFunction.RandBetween(20, 149),
> Application.WorksheetFunction.RandBetween(20, 149),
> Application.WorksheetFunction.RandBetween(20, 149))
>         For DelayLoop2 = 1 To 2000
>         Next DelayLoop2
>     Next i
>     Range("D3:D" & 20 - R).ClearContents
> Next R
>
> For R = 1 To UBound(MyArray)
>     For DelayLoop1 = 1 To 2000
>     Next DelayLoop1
>     For i = 20 To 3 + R - 1 Step -1
>         Range("D" & i).Value = MyArray(R)
>         Range("D" & i).HorizontalAlignment = xlCenter
>         Range("D" & i).Font.Size =
> Application.WorksheetFunction.RandBetween(7, 25)
>         Range("D" & i).Font.Color =
> RGB(Application.WorksheetFunction.RandBetween(20, 149),
> Application.WorksheetFunction.RandBetween(20, 149),
> Application.WorksheetFunction.RandBetween(20, 149))
>         For DelayLoop2 = 1 To 2000
>         Next DelayLoop2
>     Next i
>     Range("D" & 3 + R & ":D20").ClearContents
> Next R
>
> End Sub
>
> --- 
> --- 
> -
>
> Regards
> Deepak
>
> On Sep 7, 1:51 pm, Bheema Shankar  wrote:
>
>
>
>
>
>
>
> > Pls provide code for BLINK affect for Label caption.

-- 
--
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$$ Re: blink the Label caption

[Bheema Shankar]

thank you deepu

On Sep 7, 5:42 pm, deepu  wrote:
> Though MS-Excel is not an application where you can make high class
> animation.. but it depends on your creativity.. how do you utilize
> your knowledge to bring such an effects in Excel.. Below is the code
> that I've create, you can modify it according to your requirements,
> you might want to change formatting of the cells... Just paste this
> code in a module and run it..
>
> --- 
> --- 
> ---
>
> Dim MyArray() As Variant
> Dim  i As Integer, R As Long, C As Integer
> Dim vText As String
> Dim DelayLoop1 As Long, DelayLoop2 As Long
>
> Sub StartBlinking()
>
> vText = InputBox("Enter Any Text Upto Than 10 Chars", "Text Required")
> For i = 1 To Len(vText)
>     ReDim Preserve MyArray(1 To i)
>     MyArray(i) = Right(Left(vText, i), 1)
> Next i
> For R = 1 To UBound(MyArray)
>     For DelayLoop1 = 1 To 2000
>     Next DelayLoop1
>     For i = 3 To 20 - R + 1
>         Range("D" & i).Value = MyArray(R)
>         Range("D" & i).HorizontalAlignment = xlCenter
>         Range("D" & i).Font.Size =
> Application.WorksheetFunction.RandBetween(7, 25)
>         Range("D" & i).Font.Color =
> RGB(Application.WorksheetFunction.RandBetween(20, 149),
> Application.WorksheetFunction.RandBetween(20, 149),
> Application.WorksheetFunction.RandBetween(20, 149))
>         For DelayLoop2 = 1 To 2000
>         Next DelayLoop2
>     Next i
>     Range("D3:D" & 20 - R).ClearContents
> Next R
>
> For R = 1 To UBound(MyArray)
>     For DelayLoop1 = 1 To 2000
>     Next DelayLoop1
>     For i = 20 To 3 + R - 1 Step -1
>         Range("D" & i).Value = MyArray(R)
>         Range("D" & i).HorizontalAlignment = xlCenter
>         Range("D" & i).Font.Size =
> Application.WorksheetFunction.RandBetween(7, 25)
>         Range("D" & i).Font.Color =
> RGB(Application.WorksheetFunction.RandBetween(20, 149),
> Application.WorksheetFunction.RandBetween(20, 149),
> Application.WorksheetFunction.RandBetween(20, 149))
>         For DelayLoop2 = 1 To 2000
>         Next DelayLoop2
>     Next i
>     Range("D" & 3 + R & ":D20").ClearContents
> Next R
>
> End Sub
>
> --- 
> --- 
> -
>
> Regards
> Deepak
>
> On Sep 7, 1:51 pm, Bheema Shankar  wrote:
>
>
>
>
>
>
>
> > Pls provide code for BLINK affect for Label caption.

-- 
--
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$$ rounding to next higher rupee

[Shankar Bheema]

I am attaching an excel file with inserted userform.

I have given command button to roundoff the figure in textbox1.text to the
next higher rupee.  I have given the code as

textbox2.text=Round(val(textbox1.text),0)

but its returning wrong result.

if i have given 100.1 in textbox1.text

the result should be 102 in textbox2.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


rounding doubt.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ code for search

[dguillett1]

How about a formula
  
=INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
 


From: Shankar Bheema 
Sent: Wednesday, September 07, 2011 8:14 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ code for search

Hai all good evening

I am attaching the excel sheet which contains file numbers and names in 
corresponding file number.  I placed an userform with file no. and name with a 
command button for search.   

If we know the name and dont know the file no. by giving little part of the 
name and if pressed on the search button it should show the file number and 

if we know the file number and dont know the name by giving the file number on 
the corresponding textbox and pressing the button it should return the name of 
the employee

pls suggest me the code
-- 
--
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

$$Excel-Macros$$ problem with duplication of data

[Bheema Shankar]

I placed the following objects on my VBA excel

TextBoxes
a) file no
b) Name

Command buttons
a) Save
b) Update

In save button I have given code as@@@

Private Sub CommandButton1_Click()
ActiveWorkbook.Sheets("Employee Details").Activate
Range("A1").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If

Loop Until IsEmpty(ActiveCell) = True
ActiveCell.Value = txtfileno.Value
ActiveCell.Offset(0, 1) = txtname.Text

In Update button i have given the code as @@@

Dim ws As Worksheet
Dim uf As UserForm
Dim wslastrw As Long, filerow As Long
Dim fileno As String
Dim filefnd As Range

Set uf = formcalsheet

fileno = uf.txtfileno.Text

If fileno = "" Then
MsgBox "Please enter a valid File No."
Exit Sub
End If

Set ws = Worksheets("Employee Details")
wslastrw = ws.Range("A" & Rows.Count).End(xlUp).Row

With ws

  Set filefnd = .Range("A2:A" & wslastrw).Find(what:=fileno,
after:=.Range("A2"), _
LookIn:=xlValues, lookat:=xlPart, searchorder:=xlByRows,
searchdirection:=xlNext, _
MatchCase:=False)
If filefnd Is Nothing Then
MsgBox "No File with this File No. exists." & Chr(10) &
"Please enter a valid File No."
Exit Sub
Else
filerow = filefnd.Row
End If

uf.txtname.Value = ws.Range("B" & filerow).Value



PROBLEM IS#

while clicking the update button after giving the file number the form
will present the corresponding data to that particular number

If I modify any change and clicks the save button again a fresh row is
creating with the same number


It should be avoided.  The data should be amended in the existing row
itself.  whats wrong with the code. provide me solution

-- 
--
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 some help in transposing data

[Nishant Singla]

Hello Friends ...

I have attached the file above I have the data in this form given in the
attached file ...

I need to convert it into the format given in the attached file ...

Kindly help me ASAP ...

Regards

Nishant Singla

Mobile : 9910329711 , 9463087506

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


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

$$Excel-Macros$$ How to recast a variant as an array in VBA

[ShayneH]

Is there a way to expose an array that is enclosed by a variant?
Basically I have one function that returns a variant type which needs
to be passed to another procedure that requires the parameter to be
typed as a byte array.

eg:
Function UsuallyReturnsAnArray() As Variant

the result, after testing to be an array is passed to:

Sub ConsumesByteArray(ByRef ByteArray() As Byte)

I need to find a way to coerce the variant that contains a byte array
returned from the first function to a byte array.
Copying each element to a dimensioned array is a possible solution,
but it seems to me there must be a way to reference the array that is
contained inside the variant type.

Thanks in advance

-- 
--
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$$ Re: blink the Label caption

[deepu]

Though MS-Excel is not an application where you can make high class
animation.. but it depends on your creativity.. how do you utilize
your knowledge to bring such an effects in Excel.. Below is the code
that I've create, you can modify it according to your requirements,
you might want to change formatting of the cells... Just paste this
code in a module and run it..

-

Dim MyArray() As Variant
Dim  i As Integer, R As Long, C As Integer
Dim vText As String
Dim DelayLoop1 As Long, DelayLoop2 As Long

Sub StartBlinking()

vText = InputBox("Enter Any Text Upto Than 10 Chars", "Text Required")
For i = 1 To Len(vText)
ReDim Preserve MyArray(1 To i)
MyArray(i) = Right(Left(vText, i), 1)
Next i
For R = 1 To UBound(MyArray)
For DelayLoop1 = 1 To 2000
Next DelayLoop1
For i = 3 To 20 - R + 1
Range("D" & i).Value = MyArray(R)
Range("D" & i).HorizontalAlignment = xlCenter
Range("D" & i).Font.Size =
Application.WorksheetFunction.RandBetween(7, 25)
Range("D" & i).Font.Color =
RGB(Application.WorksheetFunction.RandBetween(20, 149),
Application.WorksheetFunction.RandBetween(20, 149),
Application.WorksheetFunction.RandBetween(20, 149))
For DelayLoop2 = 1 To 2000
Next DelayLoop2
Next i
Range("D3:D" & 20 - R).ClearContents
Next R

For R = 1 To UBound(MyArray)
For DelayLoop1 = 1 To 2000
Next DelayLoop1
For i = 20 To 3 + R - 1 Step -1
Range("D" & i).Value = MyArray(R)
Range("D" & i).HorizontalAlignment = xlCenter
Range("D" & i).Font.Size =
Application.WorksheetFunction.RandBetween(7, 25)
Range("D" & i).Font.Color =
RGB(Application.WorksheetFunction.RandBetween(20, 149),
Application.WorksheetFunction.RandBetween(20, 149),
Application.WorksheetFunction.RandBetween(20, 149))
For DelayLoop2 = 1 To 2000
Next DelayLoop2
Next i
Range("D" & 3 + R & ":D20").ClearContents
Next R

End Sub

---

Regards
Deepak


On Sep 7, 1:51 pm, Bheema Shankar  wrote:
> Pls provide code for BLINK affect for Label caption.

-- 
--
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$$ Macro to Copy the sheets from One file to Multiple Files

[SridharBL]

Ashish,

I need to save the sheets of One Workbook to 12 other workbooks.


Say, I have One Master excel work book with sheets x and y. These x and y 
sheets should be moved to other 12 workbooks.

So, now all the 12 Work books will have x & y sheets as of Master excel work 
book.

Thanks,
Sridhar BL

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

[Shankar Bheema]

Hai all

What I have a problem is,  I made an userform with all controls.  But it
wont be directly accessed without opening the excel form..

Pls suggest me a way to access directly the userform without opening the
Excel sheet.

-- 
--
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$$ code for search

[Shankar Bheema]

Hai all good evening

I am attaching the excel sheet which contains file numbers and names in
corresponding file number.  I placed an userform with file no. and name with
a command button for search.

If we know the name and dont know the file no. by giving little part of the
name and if pressed on the search button it should show the file number and

if we know the file number and dont know the name by giving the file number
on the corresponding textbox and pressing the button it should return the
name of the employee

pls suggest me the code

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


search.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ problem with cell width in a workbook

[Shankar Bheema]

I am not getting even after selection as you said.  I noticed non of the
control is allowing to work on the sheet what would be the prblem with my
excel ?

On Wed, Sep 7, 2011 at 6:31 PM, NOORAIN ANSARI wrote:

> Dear Bheema,
>
> First of all you select a range when you want to apply it...
> it work after selection...
>
> you select red font area then press it..
> Hope it will work fine..
>
> On Wed, Sep 7, 2011 at 6:24 PM, Shankar Bheema wrote:
>
>> I downloaded your file but unable to click on the command button as I
>> placed my cursor on the command button it is turning into 4 headed arrow and
>> clicking is not possible.  what to do ?
>>
>>   On Tue, Sep 6, 2011 at 11:02 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>>   Dear Bheema,
>>>
>>> Please try it and see attached sheet
>>>
>>> Sub Autofit()
>>>  If TypeName(Selection) = "Range" Then
>>> Selection.Columns.Autofit
>>> End If
>>>  End Sub
>>>
>>>
>>>
>>> Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*
>>> *http://noorain-ansari.blogspot.com/*
>>>  On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema 
>>> wrote:
>>>
 sure guruji, pls have a look at my attachment and provide me solution.

  I marked the cell data with Redcolor.  Those are to be adjusted to
 their width and remaining to their respective widths.  Kindly provide
 solution.

   On Tue, Sep 6, 2011 at 7:06 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

>   Dear Bheema,
>
> please share attachement with any rough example..
>
> --
>
> On Tue, Sep 6, 2011 at 6:56 PM, Bheema Shankar <
> shankar.n...@gmail.com> wrote:
>
>> Pls.  I need a form to adjust to the data widths of different sizes.
>> Its  a part of the form basing on your solution I have to prepare that
>> form of 3 pages.  pls provide solution.
>>
>> --
>>
>> --
>> 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.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

>>>
>>>
>>>
>>> --
>>>  Thanks & regards,
>>> Noorain Ansari
>>>  
>>> *http://excelmacroworld.blogspot.com/*
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>> --
>>>
>>> --
>>> 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.quick

Re: $$Excel-Macros$$ problem with cell width in a workbook

[NOORAIN ANSARI]

Dear Bheema,

First of all you select a range when you want to apply it...
it work after selection...

you select red font area then press it..
Hope it will work fine..

On Wed, Sep 7, 2011 at 6:24 PM, Shankar Bheema wrote:

> I downloaded your file but unable to click on the command button as I
> placed my cursor on the command button it is turning into 4 headed arrow and
> clicking is not possible.  what to do ?
>
>   On Tue, Sep 6, 2011 at 11:02 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>>   Dear Bheema,
>>
>> Please try it and see attached sheet
>>
>> Sub Autofit()
>>  If TypeName(Selection) = "Range" Then
>> Selection.Columns.Autofit
>> End If
>>  End Sub
>>
>>
>>
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>  On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema 
>> wrote:
>>
>>> sure guruji, pls have a look at my attachment and provide me solution.
>>>
>>>  I marked the cell data with Redcolor.  Those are to be adjusted to
>>> their width and remaining to their respective widths.  Kindly provide
>>> solution.
>>>
>>>   On Tue, Sep 6, 2011 at 7:06 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
   Dear Bheema,

 please share attachement with any rough example..

 --

 On Tue, Sep 6, 2011 at 6:56 PM, Bheema Shankar <
 shankar.n...@gmail.com> wrote:

> Pls.  I need a form to adjust to the data widths of different sizes.
> Its  a part of the form basing on your solution I have to prepare that
> form of 3 pages.  pls provide solution.
>
> --
>
> --
> 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.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
>>>
>>
>>
>>
>> --
>>  Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> --
>>
>> --
>> 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$$ How to develop a query for excel table

[dguillett1]

Sub Unfilter()
   ActiveSheet.ShowAllData
End Sub
Sub Filter()
 With Range("a2:f" & Cells(Rows.Count, 1).End(xlUp).Row)
 .AutoFilter field:=1, Criteria1:=Range("b16")
 .AutoFilter field:=6, Criteria1:=Range("b17")
End With
End Sub

-Original Message- 
From: Tariq Aziz

Sent: Wednesday, September 07, 2011 5:25 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to develop a query for excel table

Dear Sagar


I thing this will solve your problem.


Tariq Aziz

On 7 September 2011 13:25, Sagar Aher  wrote:

Hello,

I'm looking for query development in spreadsheet.

Pl find attachement.

My Requirement

1) Select Supplier No.
2) Select Buiness Role

Then I should get data as Supplier Name, All Name against that buiness 
role


Plz help.

--
--
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.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$$ problem with cell width in a workbook

[Shankar Bheema]

I downloaded your file but unable to click on the command button as I placed
my cursor on the command button it is turning into 4 headed arrow and
clicking is not possible.  what to do ?

On Tue, Sep 6, 2011 at 11:02 PM, NOORAIN ANSARI wrote:

> Dear Bheema,
>
> Please try it and see attached sheet
>
> Sub Autofit()
>  If TypeName(Selection) = "Range" Then
> Selection.Columns.Autofit
> End If
>  End Sub
>
>
>
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema wrote:
>
>> sure guruji, pls have a look at my attachment and provide me solution.
>>
>> I marked the cell data with Redcolor.  Those are to be adjusted to their
>> width and remaining to their respective widths.  Kindly provide solution.
>>
>>   On Tue, Sep 6, 2011 at 7:06 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>>   Dear Bheema,
>>>
>>> please share attachement with any rough example..
>>>
>>> --
>>>
>>>On Tue, Sep 6, 2011 at 6:56 PM, Bheema Shankar <
>>> shankar.n...@gmail.com> wrote:
>>>
 Pls.  I need a form to adjust to the data widths of different sizes.
 Its  a part of the form basing on your solution I have to prepare that
 form of 3 pages.  pls provide solution.

 --

 --
 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.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
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
>
> --
> 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 

Re: $$Excel-Macros$$ Reasons for increase in excel file size

[dguillett1]

Be sure to SAVE your file before rechecking. Older versions may require closing 
the file and reopening.

From: RK 
Sent: Wednesday, September 07, 2011 4:12 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Reasons for increase in excel file size

Try the following:

Press CTRL+A
Press F5
Click on special at left bottom
Choose blank
Click ok
Go to edit in the menu
Choose clear
Click all
Press CTRL+END
See if this is truly the end of your file, delete all unnecessary rows and 
column.
Again press CTRL+END
Delete all cols to the right of it and all rows below it.
Right click on sheet name and move it to a new workbook, save it and see the 
reduction in size 

Rgds,
Roopesh Kapur
E:roopesh.ka...@gmail.com




From: Divaker Pandey  
Sender: excel-macros@googlegroups.com 
Date: Wed, 7 Sep 2011 13:18:02 +0530
To: 
ReplyTo: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Reasons for increase in excel file size

you have just change cell formatting again and again. clear all formatting.and 
then apply on only used cell.

Divaker 



On Wed, Sep 7, 2011 at 10:59 AM, bé trần văn  wrote:




  2011/9/7 Amit Desai (MERU) 

What could be the reason for increase in excel file? I have a file with 
size of 4.5 MB, but data contents are not that much.



You can do the following:
- First you file your virus scanner.
- Then select all the rows and columns and delete it.
- Finally, you copy the data of each sheet and paste Special, then select 
Value and click OK.








Disclaimer: This message and its attachments contain confidential 
information and may also contain legally privileged information. This message 
is intended solely for the named addressee. If you are not the addressee 
indicated in this message (or authorized to receive for addressee), you may not 
copy or deliver any part of this message or its attachments to anyone or use 
any part of this message or its attachments. Rather, you should permanently 
delete this message and its attachments (and all copies) from your system and 
kindly notify the sender by reply e-mail. Any content of this message and its 
attachments that does not relate to the official business of Meru Cab Company 
Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email 
communications are not private and no warranty is made that e-mail 
communications are timely, secure or free from computer virus or other defect.

-- 

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

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

[John Holland]

Here is an example of the code (PastePicture is a function to paste
the graph from the clipboard into the image control; the code comes
originally from the website of Stephen Bullen and is too long to
include here).
What may happen is that the Image2-control is not filled with the
correct Chart, but with the one that goes into the Image1-control. I
conclude from this that the clipboard is not yet filled with the right
image at the moment of executing the call to PastePicture. Thus we
need to make sure, that this part of the code is executed before
calling PastePicture. Thanks for your assistance,
JH
*


Call ShowChart01
Call ShowChart02
Call ShowChart03

Sub ShowChart01()
Sheets("Chart-01").Select
Calculate
ActiveChart.ChartArea.Copy
Set frmMain.Image1.Picture = PastePicture(xlPicture)
frmMain.Image1.Visible = True
ActiveSheet.Deselect
End Sub

Sub ShowChart02()
Sheets("Chart-02").Select
Calculate
ActiveChart.ChartArea.Copy
Set frmMain.Image2.Picture = PastePicture(xlPicture)
frmMain.Image2.Visible = True
ActiveSheet.Deselect
End Sub

Sub ShowChart03()
Sheets("Chart-03").Select
Calculate
ActiveChart.ChartArea.Copy
Set frmMain.Image3.Picture = PastePicture(xlPicture)
frmMain.Image3.Visible = True
ActiveSheet.Deselect
End Sub


On 6 sep, 16:42, ashish koul  wrote:
> Hi John,
>
> please try this see if it helps
>
> after u copy  and paste  first image add
>
> Application.CutCopyMode = False
>
> this way u can check if loop is working properly or not
>
> use below statement to make it wait for 5 second then resume ur code
>
> Application.Wait Now + TimeValue("00:00:05")
>
> also can you share your code with us.
>
>
>
>
>
> On Tue, Sep 6, 2011 at 6:52 PM, dguillett1  wrote:
> > I am not understanding. Perhaps a sample file dguillett1 @gmail.com
>
> > -Original Message- From: John Holland
> > Sent: Tuesday, September 06, 2011 2:14 AM
>
> > To: MS EXCEL AND VBA MACROS
> > Subject: Re: $$Excel-Macros$$ processor to slow for proper sequential
> > processing of vba code ?
>
> > Thanks dguillett1 for your assistance, but i am not sure this is the
> > right track. Perhaps it is my lack of knowledge, but i cannot this
> > code to work. What i need is to make sure that some code is completely
> > excecuted before a next part of code is processed. How can i control
> > the VBA code to wait with processing until the physical part of a code
> > has been executed properly, i.e. put an Excel graph into the Windows
> > clipboard and paste it into an image control (HERE THE CODE NEEDS TO
> > WAIT UNTIL THIS PART IS PROCESSED), then continue with putting a next
> > graph into the clipboard and paste that one into another image control
> > (HERE THE CODE NEEDS TO WAIT UNTIL THIS PART IS PROCESSED), and so on.
> > any further suggestions are most welcome,
> > cheers,
> > JH
>
> > On 5 sep, 15:55, "dguillett1"  wrote:
>
> >> application.enableevents=false
> >> code block
> >> application.enableevents=true
>
> >> -Original Message-
> >> From: John Holland
> >> Sent: Monday, September 05, 2011 3:28 AM
> >> To: MS EXCEL AND VBA MACROS
> >> Subject: $$Excel-Macros$$ processor to slow for proper sequential
> >> processing
>
> >> of vba code ?
>
> >> I am running into the problem that some VBA code is not processed in
> >> time before a next statement can be executed. For example i want to
> >> put a certain Excel graph into the Windows Clipboard and then echo it
> >> in an image control on a userform. After that comes a 2nd graph in
> >> another image control and so on. What happens is that the statements
> >> for the 2nd graph are not executed properly because the second graph
> >> is not put into the Clipboard in time to be echoed into the 2nd image
> >> control. This 2nd image control shows the first graph in stead of the
> >> 2nd one.
>
> >> My question is if there is a way to make sure that some code is
> >> executed properly before continuing with other code?
>
> >> thanks for your kind assistance,
> >> JH
>
> >> --
> >> --**--**
> >> ---­---
> >> 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 follo

Re: $$Excel-Macros$$ Reasons for increase in excel file size

[RK]

Try the following:

Press CTRL+A
Press F5
Click on special at left bottom
Choose blank
Click ok
Go to edit in the menu
Choose clear
Click all
Press CTRL+END
See if this is truly the end of your file, delete all unnecessary rows and 
column.
Again press CTRL+END
Delete all cols to the right of it and all rows below it.
Right click on sheet name and move it to a new workbook, save it and see the 
reduction in size 

Rgds,
Roopesh Kapur
E:roopesh.ka...@gmail.com

-Original Message-
From: Divaker Pandey 
Sender: excel-macros@googlegroups.com
Date: Wed, 7 Sep 2011 13:18:02 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Reasons for increase in excel file size

you have just change cell formatting again and again. clear all
formatting.and then apply on only used cell.

Divaker


On Wed, Sep 7, 2011 at 10:59 AM, bé trần văn wrote:

>
>
> 2011/9/7 Amit Desai (MERU) 
>
>>  What could be the reason for increase in excel file? I have a file with
>> size of 4.5 MB, but data contents are not that much.
>>
>> ** **
>>
>> You can do the following:
>> - First you file your virus scanner.
>> - Then select all the rows and columns and delete it.
>> - Finally, you copy the data of each sheet and paste Special, then select
>>  Value and click OK.
>>
>> ** **
>>
>> ** **
>>
>> --
>> Disclaimer: This message and its attachments contain confidential
>> information and may also contain legally privileged information. This
>> message is intended solely for the named addressee. If you are not the
>> addressee indicated in this message (or authorized to receive for
>> addressee), you may not copy or deliver any part of this message or its
>> attachments to anyone or use any part of this message or its attachments.
>> Rather, you should permanently delete this message and its attachments (and
>> all copies) from your system and kindly notify the sender by reply e-mail.
>> Any content of this message and its attachments that does not relate to the
>> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
>> been sent or endorsed by any of them. Email communications are not private
>> and no warranty is made that e-mail communications are timely, secure or
>> free from computer virus or other defect.
>>
>> --
>>
>> --
>> 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.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

$$Excel-Macros$$ Decrease the gap between bars in Bar Chart

[Ramanjaneya Reddy]

Is there any way to decrease the gap between bars (NOT the width of the
bars) of excel bar chart?
I made a bar chart with 23 dates (weeks like 10/5/2007, 10/12/2007,
10/19/2007 etc.). The row were very thin and the gap between the rows is
long. Can we decrease the gap between the bars to make it look good?

Thanks in advance...

Regards,
Ramanjaneya

-- 
--
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$$ Rajan Verma : Most Helpful Member - August'11

[Gulam Hameed]

 

CONGRATULATIONS...

Who help others God will help them ..!

 

Gulam Hameed 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dilip Pandey
Sent: Wednesday, September 07, 2011 9:21 AM
To: excel-macros@googlegroups.com
Cc: rajanverma1...@gmail.com
Subject: Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

 

Congratulations. . .
Keep up the good work.

Regards,
DILIPandey

On 5 Sep 2011 23:00, "Ayush Jain"  wrote:
> Hello Everyone,
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> August'11
> He has posted 152 posts in August 2011 and helped many people through his
> expertise. He has been consistent contributor to this excel forum and has
> acheived this recognition for second time consecutively.
> 
> Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for
> helping excel enthusiasts voluntarily !! Keep it up !!
> 
> Keep posting.
> 
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
> 
> -- 
>

--
> 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.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$$ Conditional Formatting Excel 2007

[zp18]

A1=the name of an employee, defined name is "Suspect"
A2= an amount of money, defined as "MaxLoss"
B1:B8 is a column of money defined as "Shortages"
C1:G8 is a range of employee names defined as "Associates"


if the money contained in MaxLoss is less than the amount in column of
Shortages and the "Suspect"'s name is contained in the Associates
range then do something(bold, red, flashing etc)


The intent is to match an employees name to shortages using
conditional formatting

James$57.20 Grace   Ronnie  MernalynIrene   0
-50  $4.91  Julie   Jocelyn Tiffany Ryan
Mark
 $22.50 Grace   Ronnie  James   Irene   Mernalyn
 $(0.78)Julie   Tiffany RyanMark0
 $50.06 Grace   James   MernalynIrene   0
 $2.65  Julie   Tiffany RyanMark0
 $24.28 Grace   0  00   
0
 $(373.20)  Julie   Jocelyn Ryan0   
0

What should the statement be?  I cannot get the hang of logical
operators in conditional formatting, any help would be appreciated.

TIA

-- 
--
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$$ blink the Label caption

[Bheema Shankar]

Pls provide code for BLINK affect for Label caption.

-- 
--
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$$ Reasons for increase in excel file size

[Amit Desai (MERU)]

Thanks I have removed all the conditional formatting, but file size is still 
not getting reduced!

Best Regards,
Amit Desai

rom: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Divaker Pandey
Sent: Wednesday, September 07, 2011 1:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Reasons for increase in excel file size

you have just change cell formatting again and again. clear all formatting.and 
then apply on only used cell.

Divaker

On Wed, Sep 7, 2011 at 10:59 AM, bé trần văn 
mailto:betnmtdongna...@gmail.com>> wrote:

2011/9/7 Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>>
What could be the reason for increase in excel file? I have a file with size of 
4.5 MB, but data contents are not that much.

You can do the following:
- First you file your virus scanner.
- Then select all the rows and columns and delete it.
- Finally, you copy the data of each sheet and paste Special, then select Value 
and click OK.




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--
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.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


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail comm

Re: $$Excel-Macros$$ to get printing dialogue box on printing

[Shankar Bheema]

thank you noorain for providing solution.  I will try and let you know the
result.
On Tue, Sep 6, 2011 at 9:41 PM, NOORAIN ANSARI wrote:

> Dear Bheema,
>
> Try it...
>
> Private Sub CommandButton1_Click()
> Application.Dialogs(xlDialogPrint).Show
> End Sub
>
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Tue, Sep 6, 2011 at 8:01 PM, Bheema Shankar wrote:
>
>> I made a userform with a command button called PRINT and wrote the
>> following:
>>
>> me.printform
>>
>> but it will directly printing the form without showing the Print
>> dialogue box.  how to get that dialogue box on command.click event.
>>
>> --
>>
>> --
>> 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.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$$ Reasons for increase in excel file size

[Divaker Pandey]

you have just change cell formatting again and again. clear all
formatting.and then apply on only used cell.

Divaker


On Wed, Sep 7, 2011 at 10:59 AM, bé trần văn wrote:

>
>
> 2011/9/7 Amit Desai (MERU) 
>
>>  What could be the reason for increase in excel file? I have a file with
>> size of 4.5 MB, but data contents are not that much.
>>
>> ** **
>>
>> You can do the following:
>> - First you file your virus scanner.
>> - Then select all the rows and columns and delete it.
>> - Finally, you copy the data of each sheet and paste Special, then select
>>  Value and click OK.
>>
>> ** **
>>
>> ** **
>>
>> --
>> Disclaimer: This message and its attachments contain confidential
>> information and may also contain legally privileged information. This
>> message is intended solely for the named addressee. If you are not the
>> addressee indicated in this message (or authorized to receive for
>> addressee), you may not copy or deliver any part of this message or its
>> attachments to anyone or use any part of this message or its attachments.
>> Rather, you should permanently delete this message and its attachments (and
>> all copies) from your system and kindly notify the sender by reply e-mail.
>> Any content of this message and its attachments that does not relate to the
>> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
>> been sent or endorsed by any of them. Email communications are not private
>> and no warranty is made that e-mail communications are timely, secure or
>> free from computer virus or other defect.
>>
>> --
>>
>> --
>> 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.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