Greetings,
I am looking for a macro to accomplish following:
I have a requirement where I need to check following before closing a
worksheet:
1) If any cell (from say line 1 to 10) in column A is empty (null),
then user should be shown a message box asking him to fill in that
cell before closin
The Macro is not working.
On Fri, Sep 4, 2009 at 3:50 AM, Harmeet Singh wrote:
> *a quick solution.see attached file*
>
> On Thu, Sep 3, 2009 at 6:10 PM, Paul Schreiner wrote:
>
>> I created a macro called Gen_IDs()
>>
>> run it and it generates your summary on sheet: Summary.
>
Hi.
You should write something like :
If Ash.Columns("D").Cells.Value = "Yes" Then
For Each cell In
Ash.Columns("C").Cells.SpecialCells(xlCellTypeConstants)
...
Next cell
End if
Or
For Each cell In Ash.Columns("C").Cells.SpecialCells(xlCellTypeConstants)
HI All!
I would appreciate some direction for a VBA macro to do the following:
First I have a workbook with a summary sheet and approximately 50
individual worksheets with a specific file number on each tab. I want
to be able to search each worksheet (one at a time) and Find a
specific name in c
Hi Raj Kumar,
My knowledge says that the limit is 7, that's why we have the limit for IF
logic, i.e., we can use only 7 IFs at a time. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Sep 2, 2009
Dear All,
Thanks to excel group for all the different approaches.
It is really helpful for me to solve the particular query into various
quickest ways.
Thank you Harmeet for your quickest solution.
Dear Santosh, I understood your point also.
Thank you very much.
On Thu, Sep 3,
Thanks for the Reply,
But for the range it is not working. Please help me to fix it.
Regards,
Ashwin
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
Hi Team,
Request you to please provide any add in available to convert document into
PDF.
Regards,
Saurabh Patel
+91982814
"The earth is enjoyed by heroes"-this is the unfailing truth. Be a hero.
Always say, "I have no fear." - Swami Vivekanand
DISCLAIMER:The information contained i
On Fri, Sep 4, 2009 at 9:10 AM, Abdul Hakim Khan
wrote:
> Dear All,
> Help require either UDF OR macro or generalized Formulla for the said
> problem in attached sheet.
>
> --
> -
> A calm sea does not make a skilled sailor.
>
> Wishing you and all your loved ones greatest of times ahead!
Dear All,
Help require either UDF OR macro or generalized Formulla for the said
problem in attached sheet.
--
-
A calm sea does not make a skilled sailor.
Wishing you and all your loved ones greatest of times ahead!
Aspiring 2 c u happy!
Abdul Hakim Khan
Al Jubail KSA.
Remember, growing
Mr. Ashish
There is space in "pants".
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul
Sent: Sunday, August 30, 2009 10:31 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help
hi
thanks
On Sep 3, 6:13 pm, suresh k wrote:
> Hi,
>
> Is there any macro for copying all the data from 20 different excel file to
> a single master file.
>
> Plz let me know.
>
> Thanks & Regards,
> Suresh
Hi Syresh,
Have a look at this web Page:
http://msdn.microsoft.com/en-us/library/cc837974.aspx
On Sep 4, 12:23 am, mahesh parab wrote:
> Dear All
>
> i am getting caption error while runing the macro, i herewith attach sample
> sheet,I will greatly
> appreciate any help on this.
> Condition for if else statement
> If Column D value ="Yes"
> then Filter C column
> & copy the data
>
> Than
You have to always end the if statement
If Column D value ="Yes"
then Filter C column
& copy the data
End If
www.gate2quality.com/tools.html
On Thu, Sep 3, 2009 at 7:53 PM, mahesh parab wrote:
> Dear All
>
> i am getting caption error while runing the macro, i herewith attach sample
> sheet,I
14 matches
Mail list logo
