On Sat, Dec 17, 2011 at 10:49 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com
wrote:
The same is applicable for removing filter also.
---
Ms.Exl.Learner
---
On Sun, Dec 18, 2011 at 12:17 PM, vijayajith VA
vijayajith...@gmail.comwrote:
Sorry .
Hi vijayajith100,
There is no single keyboard shortcut for that function, but you can use
ALT-D,F,S to clear all filters without disengaging AutoFilter.
Asa
On Sat, Dec 17, 2011 at 10:47 PM, vijayajith VA vijayajith...@gmail.comwrote:
Sorry . that is for put filter and remove filter.i need to
you can use
Alt+D+F+S :- this will clear filter value but keep the filter
or
Alt+D+F+F :this will clear filter values and apply/remove filter.
From: vijayajith VA vijayajith...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sunday, 18 December 2011
fantastic explanation. thanks :)
From: Asa Rossoff a...@lovetour.info
To: excel-macros@googlegroups.com
Sent: Sunday, 18 December 2011 4:51 AM
Subject: RE: $$Excel-Macros$$ urgent,can anyone teach me Private Const
LLKHF_ALTDOWN = H20 meaning
Hi Garcia,
dont know if you got my previous mail or not but i myself didnt get it so
resending it.
From: hanumant shinde arsfan2...@yahoo.co.in
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Sunday, 18 December 2011 2:06 AM
Subject: Re:
Hi,
How to find if the command button present on Excel 2003 worksheet is ActiveX or
form control.
Also, how to add form control command button on excel 2003 sheet.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Hi,
Code is exactly the same except 1 change.
excelfile = Dir() this is used to change the name of the file.
Sub test2()
Dim path As Variant
Dim excelfile As Variant
path = C:\Documents and Settings\rjosh14\Desktop\inn\Check\
excelfile = Dir(path (*.xls))
Do While excelfile
I got your mail. Thanks for formula. But it's looking longer. Mid function
is good.
Aamir Shahzad
On Sun, Dec 18, 2011 at 4:07 PM, hanumant shinde arsfan2...@yahoo.co.inwrote:
dont know if you got my previous mail or not but i myself didnt get it so
resending it.
Hello, Dear Asa Rossoff ,
It's completely solution for my question,its fantastic explanation!
Greatly thanks your help for me.
I haven learn many from your article, take care and many thanks for
you!
With best regards
Garica
On 12月18日, 上午7时21分, Asa Rossoff a...@lovetour.info wrote:
Hi Garcia,
I am very new to Excel VBA Code so please forgive my coding clumsiness.
I have the following Code that I use to format various reports. I want to
be able to install it automatically for CSV files I open, format then save
as xls files. I have tried creating both an xla add-in file and when that
Oops, Excel 2002 on Office XP Pro OS = XP Pro SP3.
--
FORUM RULES (934+ 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
Did not find a reply to this, so assuming you haven't received the solution
yet.
The code to use in this case can be
Sub FormActiveX()
Dim objControl As Object
For Each objControl In ActiveSheet.Shapes()
If objControl.Type = msoOLEControlObject Then
MsgBox
i have two columns... zip code and the weights... i need to complete this
sheet . i.e zip codes with starting from 1001 to 9 should come up in
the sheet and for each zip code, those five weights should come up.
please advise
--
FORUM RULES (934+ members already BANNED for violation)
1)
If you can replicate this for your own sheetwell and good. Else
send the worksheet over the group as an attachemnt and I will work
that out. !! Thank you !
Sub Test()
Dim SDate As Date Dim EDate As Date LR =
Range(A1).End(xlDown).Row SDate = InputBox(Put the date from
when
14 matches
Mail list logo