Hello, I built a macro using excel 97 that does a subtotal of a list of 100 - 5000 rows x 6 columns and later removes the subtotal. This macro...

Hi I've setup a Shared Workbook which is being used by 3 different users on a LAN. We are all up-dating the spreadsheet at the same time but have found that...

I need a VBA solution and get idea after reading your web page. Thank a lot. Eric C Tushar Mehta Wrote: For a non-VBA solution, double-click the right-bottom...

G'day there AmEdee, It's AmEdee with an E in the middle, not AmAdee ;-) Sorry about that. It's the result of typing with my eyes closed =) See ya -- Ken...

Hi All, I would like to improve the schedule attached. http://cjoint.com/?ipkzvZlI8y It is the calculation of the non utilisation fee (CCNU) on a revolving...

Hi guys! Have been using tmplwiz (mallguiden in swedish) "templateguide" in my previous excelversions for a nice and easy statistics "follow-up" for a...

I can print from other programs. Also a test page from my printer is ok. But, when I try to print anything from Excel (Word) the print comes out all garbled. ...

Harald Staff wrote: Hi Mike Sub test() Dim GivenColumn As Long GivenColumn = 1 Columns(GivenColumn).Find(What:="", _ After:=Cells(1,...

I am unable to use the formats $ , % from the toolbar. If I click on them, I get a message saying :"Style not found" Currently I have to go into format cells...

=IF(COUNTBLANK(D2:F2)3,MAX(D2:F2),"") Note that there is a "less than" operator symbol just before the "3" in the revised formula above. From where you're...

I have a simple worksheet to amortise a loan. I would like to use a formula to extend the rows downwards to the number of payments (Number of years x Number of...

I need to read through a word document (Table) The table has merged cells for Heading Part No Description Price ==================== Widgets A12344 ...

How can I to add code to a Microsoft Excel's form created by program? I try with : VBCompForm =...

Are there any tempalte for inputing 3 years of sales dollars by custoemr by month and then being able update it every month? I want to us it to provide my...

I have been downloading certain financial info via the import function. Today I cannot access the data, when I check, I'm told the page is missing. Also, I can...

I'm want to create a Fantasy Football League Database / Formula Can anyone help I used to have one but my Computer got a Virus and lost the lot Thanks for...

David Thanks much---got it now. "David McRitchie" wrote: Hi Rick, Look at the #catalog example on the page. Suppose you had a table like the first...

I'm getting this error when i run a Excel macro which connects to oracle and reads data from a table Runtime error '1004' General ODBC error this marco used...