thank you santhosh
On Thu, Mar 29, 2012 at 12:27 PM, Shankar Bheema shankar.n...@gmail.comwrote:
Dear experts
I am using to take a printout of an userform by using the following code
in a command button:
me.printform
But, is there any option to take a softcopy of an unserform in a .pdf
dear all,
is there a way to disable copy from menue bar?i have protected sheet it has
disable copy but not from menue bar is there a way to do this its urgent?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
Please help,
On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey divake...@gmail.com wrote:
thanks for reply noorain
But I want as in attached snapshot. Custom Menu
hope you will help soon.
Divaker
On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan
darwin.chankaw...@gmail.comwrote:
Hi
wonder full poem in Hindi and english
2012/3/26 Ashish Saxena ashish_...@rediffmail.com
congrats noorain bhai..!!
Ashish Saxena (ASE) Delhi
Claris Lifesciences Ltd.
Mb :- 9871140113
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sent: Mon, 26 Mar 2012 23:24:39
To:
Thanks for the reply Don.
I'm still getting the same Run-time error and then an Excel crash. The
debug points to the line: Columns.Hidden = False, stating: Run-time
error message: Method 'Hidden' of object 'Range' failed.
I created a sub-procedure to display a MsgBox with the value of
Another point I wanted to note is that, when I remove the setting:
Application.ScreenUpdating = False, Excel looks like it is in some kind of
perpetual loop or at least going through a high level of CPU cycles before
it crashes.
Regards,
Anil
On Friday, March 30, 2012 11:48:10 AM UTC+1,
sir,
Here i attach an excel sheet and if i want to put vlookup for gold(column
b+column c). let me know the solution.
thanks
On Wednesday, March 28, 2012 11:34:21 AM UTC+5:30, lakshm...@yahoo.com
wrote:
ok thanks
*From:* NOORAIN ANSARI noorain.ans...@gmail.com
*To:*
Dear Lucky
Can you share sample sheet with complete explanation.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Fri, Mar 30, 2012 at 5:30 PM, Zibraan lucky60...@gmail.com wrote:
*
*
*Hi Team,*
*
Dear Excel Experts.
I need your help on the excel sheet which i have attached. I want you to help
me in building a formula based table which does the Checks.
Let me know if you have any questions.
Regards
Sreejith
--
FORUM RULES (986+ members
Send ME to MY email your file with my macro and this msg
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Anil Pandit
Sent: Friday, March 30, 2012 5:48 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of
H Friends,
I HAVE TO RENAME 72 SHEETS AND I AM USING BELOW CODES FOR RENAME SHEET.
BUT A1 RANGE CHARACTER TOO LONG I WANT RENAME EACH SHEETS HAS 20 CHARACTER
OF RANGE A1.
PLS CHANGE THE FORMULA AND SEND ME BACK.
THANKS IN ADVANCE.
Sub RenameTabsHandlingNulls()
' Renames all worksheet tabs
Hi,
Your trade ID is not unique. So how do you decide, which in detailed sheet
row you need to compare with which row in summary sheet.
Example if your trade id is TD20120325, there are multiple rows in detailed
sheet with this trade id, so which row do you take as reference for
comparision?
Dear Sreejit,
Please use it..
=OFFSET(INDEX(Detailed!$A$2:$K$2,MATCH($B11,Detailed!$A$2:$K$2,0)),MATCH($C$8,Detailed!$A$3:$A$13,0),0)
see attached sheet.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
Dear Amresh,
Please try it..
Sub RenameTabsHandlingNulls()
' Renames all worksheet tabs with each worksheet's cell A1 contents.
'If cell A1 has no content, then the tab is named as Default
*Dim sh As String*
For i = 1 To Sheets.Count
*sh = Left(Worksheets(i).Range(A1).Value, 20)*
If
Dear Amresh,
Please check it if this code is not working send a sample sheet
On Fri, Mar 30, 2012 at 8:30 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Amresh,
Please try it..
Sub RenameTabsHandlingNulls()
' Renames all worksheet tabs with each worksheet's cell A1 contents.
'If
Show AFTER examples and why
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: rajeyssh
Sent: Friday, March 30, 2012 6:45 AM
To: excel-macros@googlegroups.com
Cc: LAKSHMAN PRASAD
Subject: Re: $$Excel-Macros$$ vlookup with more than one value
sir,
Here i attach an
Start over by telling us what you are trying to do... Code can be greatly
simplified. Pls do not use “urgent” in your request. It is rude.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Zibraan
Sent: Friday, March 30, 2012 7:00 AM
To:
check this http://www.rondebruin.nl/ribbon.htm#Examples
On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey divake...@gmail.comwrote:
Please help,
On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey divake...@gmail.comwrote:
thanks for reply noorain
But I want as in attached snapshot.
http://www.rondebruin.nl/ribbon.htm#Examples
On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey divake...@gmail.com wrote:
On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey divake...@gmail.comwrote:
Please help,
On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey divake...@gmail.comwrote:
Very useful link Ashish, Thanks to sharing with group
On Fri, Mar 30, 2012 at 9:37 PM, ashish koul koul.ash...@gmail.com wrote:
http://www.rondebruin.nl/ribbon.htm#Examples
On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey divake...@gmail.comwrote:
On Fri, Mar 30, 2012 at 12:44 PM,
Hi seema
long time back I created this addin to search on Google . I am not
sure how much accurate result will it give now . you can try it and
make changes in the code as per your requirement.
Download Link http://www.box.com/s/ab954ee4970bae3bf815
(File is too heavy so i have uploaded it on
Hello Sreejith,
As Seema said, not sure about how do you want to compare due to duplicate
trade ID's. If you are looking to total the headings based on TradeID's use
SUMIF.
In C11, then copy down. Assume Trade Id always be in column A in detailed
sheet
*
Try this
http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/
Regards,
Sam Mathai Chacko
On Fri, Mar 30, 2012 at 9:37 PM, ashish koul koul.ash...@gmail.com wrote:
check this http://www.rondebruin.nl/ribbon.htm#Examples
On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey
20 still sounds like a lot to me. I suggest a TOC on a menu sheet with a
doubleclick macro to goto the sheet desired.In fact, you may even want the
sheets to be named 1,2, etc.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Friday, March 30,
Dis you NOT read what Sam said about what you just did???
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ChilExcel
Sent: Friday, March 30, 2012 3:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Unprotect - VBA Password
Please see
Chil, please abide by the rules too. it defeats the purpose of the rules to
answer those questions and it disrespects the admin.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: Friday, March 30, 2012 1:55 PM
To:
glad to help
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Preston Moore
Sent: Friday, March 30, 2012 1:58 PM
To: excel group ; dguille...@hmail.com
Subject: RE: $$Excel-Macros$$ Test to see if cell value starts with a D
Don,
Thank you for your help; it works
Don Guillett ,
Thanks Great.
On Fri, Mar 30, 2012 at 8:54 PM, dguillett1 dguille...@gmail.com wrote:
try
*http://tinyurl.com/85lubjc*
‘
HI,
PFA.
Regards,
MARIES.
On Fri, Mar 30, 2012 at 4:46 PM, hilary lomotey resp...@gmail.com wrote:
Hi Maries
i keep sending to group but it bounces can you help?
pls how do you trim an excel sheet such as done in the attached file(screen
shot). ie if
you look at Menuerror legal sheet,
Thanks all members for taking notes of my query, I will try at my level and
come back to u
thanks once again.
Govind .Mori
On Thu, Mar 29, 2012 at 11:46 AM, Asa Rossoff a...@lovetour.info wrote:
Govind,
Correction… I seem to have been mistaken. File, Open. Change the file
types
30 matches
Mail list logo