I am having the following code: OSHEET.CELLS(2,3).SELECT MSGBOX OSHEET.CELLS(2,3).VALUE MSGBOX ACTIVECELL.VALUE The cell is having value, but still, its...

I thought it should be easy. I'm writing a macro. The first part leads the Active Cell to a location depending on the value of various (declared) variables. ...

Hi, Spreadsheet with many columns: In All column, Row4 I have dates: What I like to do is: "IF" I am in Column y "Any row" I would like to go up to...

I have a excel add-in installed on my system. When i try to work on the add-in i get the following error "activex component cant create object". Please help...

I have a spreadsheet with about 13,000 song entries... Col a artist col b song title.. Iv'e read advanced filter tutorials till I'm blue in the face.. All I...

I have data 1 tru 200 with time "12:01:04". How can I add a hour to read "1:01:04" so when they move the clock in March '10 I will have the correct...

I want 1 point to be added to A1 if A2 equals 10,000. A2 is the sum of other cells. I need A1 to be save. Right now, it goes back to previous score when A2 is...

Hi Have had help with this, but still short of goal criterea 1) Weekday anything after 1600 is classed as next day's date 2) anything after 1600 on friday,...

I have 5 workbooks each with 6 worksheets. Each worksheet has 33 rows and 5 columns with data (numbers). How do I add the 6 worksheets into one...

If I have a shipping spreadsheet that has a shipping cost shown by weight on the left and zone on the top , how can i select all fields and add a certain...

If you are only concerned about how it looks (not changing the value), you can give that cell (column of cells???) a custom format: Select the...

I have a voucher I created in an excel spreadsheet (not a form or anything but on the worksheet itself). I need to be able to have the users click on a...

In the audit formula auditing section it would be nice to have a small arrow or back button when going to links to get you back to your previous cell. ...

Hi, Is there a formula that would add a space between two characters? I have "12:13:09", I would like to add a space before the first colon. (12 :13:09) --...

I have a column of part numbers that I want to re-identify with a "W" in front of the number. There has to be a quick way of doing this but everything I...

For example, In excel in cells A2 to A56 I've got words in them, I wanted to copy all the cells in column A to B in same order,but when the word "check" is...

Hello, I have a column (A) with a price from row 1 to 100. I would like to create in column B a formula that will add the total in each row. Example B2 will...

I have a summary worksheet with several others as back up data - ie company budget summary with branch budget worksheets. I need to add various...

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

Is there a way to add a colon (:) to times? Example: At the moment I have A1 (hours) 2 B1 (minutes) 4 C1 (seconds) 8.321 I want these to end up in a...