Hi Firiends,
I need to reduce the Excel File size, my file went beyond 30 MB. Please help
me.
--
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks a
Hi Paul,
Thanks a ton for your help.
I am financial guy and I know only 20% coding in VBA. I am on the way
to learn VBA.
I get an idea with following code. I need one textbox in same form
above the unique item text box to search the item from unique item
list.
Further this form takes lot of time
Hi Bob,
I have done something in the attached file.
I believe if the x and y are not fixed at all the time, then we can
use Goal Seek feature of Excel to obtain the desired results.
Question:- How are you determining X and Y when you already have As and Bs.
Best Regards,
DILIPandey
On 11/23/10,
Hi Rajesh,
You can use following code:-
Sheet1.Visible = xlSheetVeryHidden
Or
Sheets("Sales").Visible = xlSheetVeryHidden
Now, you can not see it using Format->Sheet-> unhide
To get it, use following code
Sheet1.Visible = True
Further to this, you can protect your VBA code as well, so that no
I'm not as good at VBA as I'd like to be and I especially thank you
for taking the time to explain each step, I found it very helpful!
Pertaining to the unique name problem, I looked but was unable to find
a way to add a letter at the end of the date, starting with B going up
to M (though if I get
I'm not as good at VBA as I'd like to be and I especially thank you
for taking the time to explain each step, I found it very helpful!
Pertaining to the unique name problem, I looked but was unable to find
a way to add a letter at the end of the date, starting with B going up
to M (though if I get
What you describe is easily done.
However, I wouldn't be a very good teacher if I simply GAVE you the answer!!!
;-)
You've described things nicely.
Now think in terms of how you get Excel to go through the steps.
-
1) I need everythi
> you can NEVER return a "2" which represents:
> "If every year since the max experienced a percent increase"
Ah! Oops.
And thank you for the macro. I will try it out.
As for this:
> Second is somewhat of a "logic" issue:
> you really don't need to know what the PERCENT increase/decrease per ye
Hello experts,
I have attached a sheet that I've been working on that is part of a
multi-step task that I have so far managed to cut over an hour a day from
the workload.
Overview:
I get roughly 50-80 emails daily with flight information related to my
company that previously was completed by some
Hi Vaibhav,
Thanks for your suggestion.
But as per my office procedure I could not download any thing from google or
get inside the office premises. I am requesting this for my official Usage.
So I am expecting to doing it through Excel Macro.
Please help me out if you have any codings to do th
hi Ashish,
there are some differences in methods between 2003 and 2007 versions.
The method Create of PivotCaches is not present into 2003 version and
replaces the method Add.
regards
r
2010/11/24 OpenExcel.com
> HI Raj,
>
> You can use the below mention code:
> Focus on arguments and understa
Sorry Herman,
I didn't mail you directly.
You received this because you've subscribed to the
Excel-Macros group in Google.
(actually, it's called: MS EXCEL AND VBA MACROS)
I simply responded to a message posted to the group.
If you would like to stop receiving emails from the GROUP,
you need to l
Hi Prasanna,
Contact us on 0-40-48-43 / 09986-615-632.
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
_
HI Raj,
You can use the below mention code:
Focus on arguments and understand them, it's easy, you'll never
forget.
ThisWorkbook.PivotCaches.Create(SourceType:=xlDatabase, _
SourceData:="Sheet2!R2C2:R6C6", _
Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:=
Hi Paul,
Please stop mailing me.
Gr.
Herman
-Oorspronkelijk bericht-
Van: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
Namens Paul Schreiner
Verzonden: woensdag 24 november 2010 14:47
Aan: excel-macros@googlegroups.com
Onderwerp: Re: $$Excel-Macros$$ Re: Long
Do you already have the userform?
or should I start from the beginning?
Paul
- Original Message
> From: Manish Pansari
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, November 24, 2010 5:52:04 AM
> Subject: $$Excel-Macros$$ Re: Long List problem
>
> Hi,
>
>
> Any help please
>
>
> T
what i need is that i have many files in my computer each having a
many worksheets
among this many of the sheets contain datas which is not allowed
others to access
if i am simply hide a sheet or range they will understand that some
sheets or data is hided here .i want to over come this. normaly no
Hi,
Any help please
Thanks
On Nov 24, 11:17 am, Manish Pansari wrote:
> Hi All members,
>
> I have data in more than 2000 rows. I created drop down list through
> data validation option in excel. But its very hard and difficult to
> search the required name through long list.
> I want to crea
hi Group,
Can any one send me the macro commands to create pivot table in excel.
Thanks & Regards
Rajesh
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitt
Hi All members,
I have data in more than 2000 rows. I created drop down list through
data validation option in excel. But its very hard and difficult to
search the required name through long list.
I want to create a macro with search option user form. When I click
the macro, one user form will ope
Hi,
Thanks all for the repy.
On Tue, Nov 23, 2010 at 7:08 PM, roberto mensa wrote:
>
>
> 2010/11/23 Chandra Shekar
>
> Hi,
>>
>> Thank you for the reply, if I run this macro excel will start flickering.
>> How to stop this please run the program and see. Thanks
>>
>> Regards,
>>
>>
>
> try:
>
Hi Jose,
I am very new in excel macros...
Can you pls share your macro file with me, I am also want to
transparent one user form in my module.
Thanks in advance.
Manish
pansari.man...@gmail.com
On Nov 18, 3:11 pm, Alfred WALLACE wrote:
> Hi to all gurus (day gurus, or night gurus !)
>
> My pro
Yes. Cool stuff.
Thanks for the help.
Regards,
C.G.Kumar
On Tue, Nov 23, 2010 at 4:03 PM, kiran Kancharla wrote:
> U need to change the options.
>
> Tool ---> Options --> General "Zoom on roll with Intellimouse"
>
> This has to Uncheck.
>
>
> please try and let me know.
>
>
>
>
> On Tue, No
23 matches
Mail list logo