Hi,
**
*Try this code:*
**
Sub Macro1()
Cells.Select
Selection.RemoveSubtotal
End Sub
Regards,
MARIES.
On Mon, Feb 6, 2012 at 11:37 AM, chandra sekaran duraichan...@gmail.comwrote:
HI ALL
I have write small macro , i want revmove subtotal if Active sheet
subtotal method is
Hi charlie,
Got it.
Ok, the error is just indicating that the vlookup failed to find the Part#.
It failed for at least two reasons: (1) The VLookup is in the Change event,
which fires after every change, such as after each keypress - -so the whole
part# was probably not entered yet, and (2) The
Dear Excel Group Member,
Please give the some example of index function Match Function how can
use both function in combined.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Kindly check below links
http://www.techonthenet.com/excel/formulas/index_function.php
http://dmcritchie.mvps.org/excel/vlookup.htm
http://www.ozgrid.com/Excel/left-lookup.htm
On Mon, Feb 6, 2012 at 3:33 PM, Jai jaihumtu...@gmail.com wrote:
Dear Excel Group Member,
Please give the some
Dear Friends,
I am using excel 2007 and my files are not opening in the first attempt if
i minimize the window and maximize or right click inside open or new then
once the contents will show. Please let me know how can i rectify the error.
--
Thanks Regards,
Mohamed Idhrees. S.
--
FORUM
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Somnath Khadilkar
Sent: Sunday, February 05, 2012 8:43 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a small MACRO to SPLIT
Many thanks Don Guillett Sir,
You hv
Your macro worked on sheet 1 because you were on sheet 1 and didn’t work on
sheet 2 because your with did not have the necessary dots.
with sheet2
.do it
.do that
.do anoither
end with
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Sunday, February 05, 2012
Your life would be simpler if you designed withOUT all of these userforms, etc.
KISS
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Sunday, February 05, 2012 10:59 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ datediff doubt
Dear Experts,
I
Regards,
Muneer,
CC...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2)
thank you so much
On Mon, Feb 6, 2012 at 7:04 PM, dguillett1 dguille...@gmail.com wrote:
Your macro worked on sheet 1 because you were on sheet 1 and didn’t
work on sheet 2 because your with did not have the necessary dots.
with sheet2
.do it
.do that
.do anoither
end with
Don
Thanks again for your assistance Don, your help is very much appreciated.
John
On Mon, Feb 6, 2012 at 10:03 AM, dguillett1 dguille...@gmail.com wrote:
Place in a module and save the file as macro enabled. xls or .xlsM
‘==
Option Explicit
Sub lineemupSAS()
Dim i As Long
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
From: John A. Smith
Sent: Monday, February 06, 2012 9:11 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows
Thanks again for your assistance Don, your help is very much appreciated.
I’m confused. Start over with a better explanation and before/after examples
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Monday, February 06, 2012 8:08 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extract the single word called cell from
Thank you sir, its working
with regards
raghu
On Mon, Feb 6, 2012 at 8:20 PM, The Viper viper@gmail.com wrote:
check the attachment and go to rate sheet
On Sun, Feb 5, 2012 at 2:13 PM, raghu gr balaji.bra...@gmail.com wrote:
hi,
Thanks a lot sir,
For the same type of file i tried
Dear Raghu,
You can use..
=VLOOKUP($G$2,CHOOSE({1,2},RATESHEET!$B$6:$B$9,RATESHEET!$C$6:$C$9),2,0)
See attached sheet..
On Sat, Feb 4, 2012 at 12:02 AM, raghu gr balaji.bra...@gmail.com wrote:
Hi experts,
I have a invoice file and summary file, i want the formula in rate column,
which
Thanks boss
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: dguillett1 dguille...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 6 Feb 2012 09:50:15
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
To keep it shorter, and more efficient, one could write
Sub ClearSubTotal()
ActiveSheet.UsedRange.RemoveSubtotal
End Sub
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 2:16 PM, Maries talk2mar...@gmail.com wrote:
Hi,
**
*Try this code:*
**
Sub Macro1()
Cells.Select
A more appropriate event for this case would be the Exit event. You can
just type in your number, for example 3 and hit the ENTER key. And
generally speaking, the lesser the lines, the more efficient the code.
Private Sub TextBox8_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox5.Value
Hi sam,
If Subtotal method is there than only remove subtotal works , in that
case whether subtotal paticular sheet is there or not if subototal method
is there i will use below code will work.if not thereby pass
remove subtotal then subtotal commant will work this my query
There is no object model in Excel which tests the use of subtotal in a
worksheet/range.
The closest you could get is to look whether the used range has something
like an =SUBTOTAL(*) somewhere, and then use the code that I suggested
below. But that would then not be fool proof. The possibility
HEre's a discussion on this topic. Scroll down to a little over the half
way mark, and you should find a few probable solutions. One was about
deleting the pdfmaker file (do you have that?). Second was about changing
some setting in Excel. Either way, I haven't faced this myself, so no
solutions
The text can be formatted by having the space *within* the format
=CHOOSE(A1,C2,C3,C4,C5)TEXT(C10/I1, 0,0.00)
or using Don's suggestion
=INDEX(C2:C5,MATCH(D12,D2:D5))TEXT(C13/INDEX(E2:E5,MATCH(D12,D2:D5)),
0,0.00)
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 10:31 PM,
Your txtavgto1.Value in form 2 is empty during execution of the form
initialize event. I have just added a conditional statement to work around
the error.
Now, your objective is not clear. So you might want to rephrase.
Second, I am of the same opinion as Don. It seems you have generated an
Thanks Sam.you guys are genius. VEry grateful
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Sam Mathai Chacko samde...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 7 Feb 2012 00:40:37
To: excel-macros@googlegroups.com
Reply-To:
Your use of the CHOOSE formula here is absolutely obsolete.
Having CHOOSE({1,2},RATESHEET!$B$6:$B$9,RATESHEET!$C$6:$C$9) is equivalent
to simply using RATESHEET!$B$6:$C$9
Instead, you could have passed the column number dynamically by looking
were the CR COIL is located. For this you could have
As many of you know, I adhere to the KISS principle and rarely use all of these
forms or a lot of CF. I prefer to have a macro do the work. In fact, on many
projects I do not even use visible formulas. I also like to breakup vlookups,
etc into meaningful blocks instead of entire columns. ie:
Nice
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Monday, February 06, 2012 2:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows
If your rows go in to the thousands, using autofilter will add a bit more
(~40%)
Hi Charlie,
I don't have a lot of practicle experience in all areas of Excel, so I just
realized there is an easier way to link controls to the worksheet!
Simply use the ControlSource property of the control and provide a cell
reference or named range. See
Wow, thanks Sam. When I was trying this myself, I started down this
approach and couldn't make it work. Thanks for the lesson.
John
On Mon, Feb 6, 2012 at 3:06 PM, Sam Mathai Chacko samde...@gmail.comwrote:
If your rows go in to the thousands, using autofilter will add a bit more
(~40%)
Sorry Don, please check the attachment its very clear in it.
Regards,
Muneer,
CC...
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1
Sent: Monday, February 06, 2012 6:56 PM
To:
Hi Muneer
The original attachment is not at all clear. Neither Don nor I have the
faintest idea what you want. Could you send another attachments with added
the result you want where you want it? I.e just fill in the shaded cells
(if that is where the result goes) with the values you would
del cell
bel cell del
cell bel del
cell ell llec
blood consist of red cell and white cell
simos is a cell
max cell
sony cell
a cell is a source of energy for some electronic devices and stands as a
two way power.
Above mentioned lines are having the word cell in common,
Hi Asa and Sam
Thanks for all the info. It will take me a couple of days to comprehend it
all and then I will get back to you.
I really appreciate your help
Regards
Charlie
On Tue, Feb 7, 2012 at 12:10 PM, Asa Rossoff a...@lovetour.info wrote:
Hi Charlie,
I don't have a lot of
Dear sam,
Thanks for your valuable Advice
Regards
chandru
On Tue, Feb 7, 2012 at 12:22 AM, Sam Mathai Chacko samde...@gmail.comwrote:
There is no object model in Excel which tests the use of subtotal in a
worksheet/range.
The closest you could get is to look whether the used range has
Dear Team,
Does any have excel training ppt or module for Basic Advance. If yes, please
forward it with sample file.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged
Dear Team,
Please forward excel test file for basic advance level, if anybody have it.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
On Sun, Feb 5, 2012 at 2:05 AM, Hemant hemantda...@yahoo.com wrote:
Good way to make some additional money.
http://hidayeterkan.com/home.work.php?gugmailID=a7et9
--
FORUM RULES (986+ members
37 matches
Mail list logo
