Last column no.
Tue, 27 May 2008 04:00:00 -0700
Hi,
Need a help.
1. Macro to get final Last row no. from the user
2. Calculate the TAT (diff. between any two column) with the last row no.
Your help on this would be highly appreciated.
Bye,
Sivassou. ...
|
smtp
Tue, 27 May 2008 03:55:00 -0700
how to setup to hotmail. com\outlock exp
smtp&pop ...
|
Excel 2007 auto-recovery / auto-save?
Fri, 23 May 2008 14:19:01 -0700
I have an large spreadsheet where the data is populated via a connection to
databases via MS Query. In addition to this data there are various lookup
tables used to enhance the data downloaded from the query. This issue that i
am having is if i need to make an adjustment to one of the lookup tables
excel a ...
|
editing setup defaults
Fri, 23 May 2008 11:06:00 -0700
In Excel 2002, when I open an existing worksheet, it automatically opens a
blank excel template. How do I turn this off? ...
|
Can you set up a global footer (filename & ext) on all wsheets
Thu, 22 May 2008 07:31:01 -0700
Is there a way to set a global footer for all workbooks to print the filename
and extention at the bottom of the sheet without setting it for each workbook
you have and for new ones opened? ...
|
where the archieve folder deleted mails are stored
Thu, 22 May 2008 04:54:00 -0700
In outlook i used to keep all the mails in Archieve folder. Two days back i
am not able to open the archieve folder and the error msg shows as "The
Server is not availble". I checked the same with my administrator and they
said the server link is available. In that Archieve folder i have more than 2
years ma ...
|
Formatting cells
Wed, 21 May 2008 19:09:25 -0700
I notice that when I use the "rich" graphics options available in EXCEL to
format presentations and worksheets, I occasionally run up against a common
error message: "Too many cell formats!"
Now to be frank, I rarely come across this until workbooks get to be about
2.5 MB or over 3-7 worksheets deep. Ina ...
|
|
|
Excel puts quotes around cells with commas in tab delimited files
Wed, 21 May 2008 15:36:07 -0700
Excel puts quotes around cells with commas in tab delimited files. I don't
want it to do this. How do I prevent it? ...
|
How do I create checkboxes in Excel 2007?
Wed, 21 May 2008 04:58:01 -0700
Hi,
I'd like to add some checkboxes to a particular column in a spreadsheet I'm
creating but I can't find any easily apparent way to do this on Excel 2007.
Can anyone advise?
Thanks ;0)
--
CNF ...
|
Solution for stdole32.tlb issue with excel and vista
Wed, 21 May 2008 02:54:03 -0700
This may not sound very scientific, but after hundreds of wasted hours of
searching and experimenting, here is what I did and it works !
1. Uninstall all Microsoft Office 2007, 03 etc versions.,
2. Uninstall all MS Office file convertors, support software for desktop
gadgets, downloaded patches, etc
3. Go to ...
|
