Dear,
You need not to worry. If you have Office 97 CD, you just install it on your
PC (in case Office 2003/2007 is not provided by the vendor).Office 97 will
work of Windows 7. In addition , if you install office 2007 then also you
will be able to work with office 97 file created earlier.
Hello,
You can select the Auto filter results only but before copying you must
choose the option of Select visible cells only (ALT+;) then chose copy and
paste the result wherever you require it.Without using the option of select
Visible cells every result will be copies as if there is no auto
Dear,
Right Click Cell
Format
Number Tab
Select Number
decimal place is 0
ok
Regards
Sumit Vyas
+919755549483
On Sat, Sep 11, 2010 at 8:00 PM, Saurabh Patel
saurabh.pa...@in.aegisglobal.com wrote:
Change the cell format to Number by right clicking on cell.
Regards,
Saurabh Patel
Right click the Text Box, Select properties.
set the EnterKeyBehavior Property to true and
set the multiline property to true.
That's it.
Bye
Regards,
Kishan Reddy, K
On Sep 12, 8:09 pm, Johnnyboy5 intermediatec...@gmail.com wrote:
How do I get the text box to line feed on pressing enter
Dear Sirs,
I want to capture data which employees are on leave as on date and
since when ?
Formula please…..
(Format enclosed)
NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep Leave Since
A AB AB AB AB AB AB AB 01-Sep
B pr pr
Hi ,
Your Welcome. If you need any help ,I will try to solve it.
On Mon, Sep 13, 2010 at 8:26 AM, Meimei xxu8810...@gmail.com wrote:
Thanks to both Neil and Paul. The VBA file Neil posted is similar to
what I need, except I would need the result in a sorted order, that is
why I was thinking
Hi Everyone,
Can Someone Explain about Listbox properties in VBA. . When I use listbox in
user form . and list box properties. there is *COLUMN COUNT* . *Why we user
-1 in Column Count?* Please explain the properties of LIST BOX except this
question.
Thanks and Regards
--
hi all,
is it possible to create a macro that launches others 5 macros?
someone can help me? many thanks.
Fede
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi,
Yes, you can use Call
eg:
Sub Run5Macros()
Call Macro1Name
Call Macro2Name
Call Macro3Name
Call Macro4Name
Call Macro5Name
End Sub
Regards - Dave.
Date: Mon, 13 Sep 2010 01:02:15 -0700
Subject: $$Excel-Macros$$ create a mcro in xls that launches
You all might have see that even when i format the cell/column as
number, it dont show me the exact number i do enter there.
Vijay
On Mon, Sep 13, 2010 at 11:35 AM, SUMIT VYAS svyas0...@gmail.com wrote:
Dear,
Right Click Cell
Format
Number Tab
Select Number
decimal place is 0
ok
Maries or any of teh EXCEL group friends, could you please email me
that 100 years diary document on my e-mail morur...@gmail.com, I
cannot manage to download or open the file by following the link.
Please guys, I beg, I beg, I beg, I beg and I BEG!
I AM LOOKING FORWARD TO YOUR RESPONSE.
Regards
Hi,
20 digits is too much for XL, which I think only handles 16 digits accurately.
If you really need accuracy to that degree, you'll have to go elsewhere, or
start splitting the number over 2 cells, which makes the maths quite complex.
If you Google Big numbers in Excel you'll see lots of
Pls. check ur mail... i forwarded.
On Mon, Sep 13, 2010 at 4:32 PM, Shimmy morur...@gmail.com wrote:
Maries or any of teh EXCEL group friends, could you please email me
that 100 years diary document on my e-mail morur...@gmail.com, I
cannot manage to download or open the file by following the
look this link:
https://sites.google.com/site/e90e50/vba/rimuoverepasswordexcel
regards
r
2010/9/13 vikas gupta vikas.63...@gmail.com
Dear All
I have a protected excel file can any one unprotect it
regards
vikas
--
=IFERROR(VLOOKUP(D2;A1048560:B1048563;2;0);)
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ALAM
Sent: Monday, September 13, 2010 3:24 PM
To: excel-macros@googlegroups.com; toexcel-mac...@googlegroups.com
Cc: noorain.ans...@gmail.com
Subject:
take format cell as number
On Sat, Sep 11, 2010 at 5:39 PM, viju mobile vijumob...@gmail.com wrote:
Hi All,
I am trying to input 20 digit number in a column. But it does not
enter it correctly.
Please guide me.
Regards,
Vijay
--
can you please attach excel file
On Mon, Sep 13, 2010 at 11:57 AM, Nalini nalini.pradha...@gmail.com wrote:
Dear Sirs,
I want to capture data which employees are on leave as on date and
since when ?
Formula please…..
(Format enclosed)
NAME01-Sep 02-Sep 03-Sep 04-Sep 05-Sep
Hi Team:
So Attached I have a small table, I need to create columns where the headers
appear next to the data. Can anyone assist, please?
Pivot tables don't work because they don't refresh correctly when utilizing
macros.
Thanks
Michael
--
Please guide about the process
--- On Mon, 9/13/10, N.Shivkumar shiv1...@gmail.com wrote:
From: N.Shivkumar shiv1...@gmail.com
Subject: Re: $$Excel-Macros$$ PLEASE UNPROTECT THE SHEET OF ATTACHED FILE
To: excel-macros@googlegroups.com
Date: Monday, September 13, 2010, 7:10 PM
Kindly have a look
Hi Team,
Please help on the attached.
Thanks in advance.
Regards,
Hemant Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
This looks like an amasing piece of work
Harpreet Gujral
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Hello,
You can also find a wide variety of useful templates in the New section of
Excel ribbons button in Excel 2007.
Regards,
Vijaykumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for
22 matches
Mail list logo
