I'm using Excel '03 and filling cells w/ a color (with the paint bucket). The color does not show up in my spreadsheet, but does show up when I print. Every...

I would like to prevent any changes to an Excel 2003 spreadsheet except for the contents of cells. Is there a way to protect the formating of a worksheet, but...

Is there a way to change what is displayed on a hyperlink in vb code? I would like for a input box to appear and ask what name would you like to call the...

I have a list of customer names in cells A87:A?? I need to sort this list, but the list might get longer when names are added. I have a VBA code that adds the...

I feel like a dummy for asking, but, I've played with Page Setup, Page Break, Print Area, etc., etc. and can't figure out how to resize the printed image. I'm...

Can I set some aspect of the cell format based on a formula value? For example, I would like to change the cell fill color based on whether the value in that...

I have a problem I have created a hyperlink to a picture on my hard drive and when I click on the hyperlink it does nothing. How can I make excel show...

I have a large macro I wrote, and which I've used for some time. It takes a string of characters and parses it into separate cells using some arcane...

I have a spreadsheet with colums one with number and second with alphabetic list . Now i wanted to add the same word RR3 to the right end of each row of the...

I need a macro to do the following in B3:B500 If(right(......,5)="Total" Delete Right(........,6) Hope this is clear

hi, anyone to solve my problem ? I have an Abacus that contain : Cell B1 to R1 contain (CABLE SIZE): 4mm, 6mm, 10mm, 16mm, 25mm, 35mm, 50mm, 70mm, 95mm,...

the calculation that i require is for eg. 9am -7am = 2hours or 120minutes, expressed in the hh:mm format, but if the answer is a negative i get ####, thus i...

I want to change a formula linking to a cell in a workbook on another server so that the server name is used rather than the drive mapping. I have tried the...

I am trying to open two different program files, one after the other, in VBA within an Excel macro. This is what I have so far: Shell ("C:\Program...

Please help!!! I am trying to lookup a value in Access but am having problems with the code. I have seen the code others have used on this forum, but I...

I cannot find the Excel 97 SR-1 patch on the office website. Where can I get it?

i need to check to see if a given range of cells each fall within a range. Say I had a column of data like this: 2 3 6 3 4 I want a statement that checks to...

How do I change the excel worksheet that automatically opens when I start the program?

Hi, I have a problem. I have in column A a system tag 202.E.0716/LN114-01. I want another column to automatically give me 202E0716LN11401. I have more than...