double

Good Evening, I have an ETA calculator (Time/Distance= Speed) that is giving me an error. Now the error takes me to various other bits of codes like my timestamp macro but it's all based on one part here. The Distance (DTG) below is the cause. If I input data into the "S29" cell, it works...

Hi, I have a sheet where the headers i want to sort start in row 4 and the data is below. The first column with data is column B. Depending on the sheet there are different numbers of columns and a different number of rows. I read that it is possible to sort data by double clicking on the...

Hi guys. I have a spread sheet with multiple options on there. Previously I had used hyperlinks to link to word documents for the shipping labels but people are clicking by mistake a making a right hash of things so I am now looking at adding VBA code where you would double click a set cell and...

Hey Guys- I have this If Then piece I've put together that's supposed to choose one of two formulas for a cell, based on what the previous sheet is, and then input that formula into the cell. It does this for two different cells. Currently I have something wrong because both cells just come...

Hello All, How can we know whether the excel file is opened from a batch file accessed through Command prompt Or manually by double click. Need to call different functions based upon this condition. Thanks in advance. Thanks, Rahul

I am using VBA calendar to input dates in my workbook. I have added code to my worksheet to call calendar on double click of cell. So basically when I double click cell in range I get calendar form, where I pick up the date and then it is inserted in double clicked cell. The problem is if I...

Omigosh I'm about to lose my mind. Why is Excel taking me to the fifth cell in my formula instead of the first?! All that mattes here is that I want to go to CA325 if I double click or ctrl +{ (YES, "Allow directly editing in cells" is OFF) =(CA325*0)+...

I'm stuck. I can't find a way to protect my sheet while allow users to double click in a cell, use data validation list in the same cell while protecting shapes from being edited. When I set DrawingObjects:=True the shapes are protected but I can no longer double click in a cell that has a data...

i have a formula in cell A2 with a text output. I need to add double quotes at beginning and end. however if I try to use this code i.e. a double quote inside a pair of double quotes as you would add any other text ="""&A2&""" I just get this which isn't helpful <tbody> "&A2&" </tbody>...

We have been using an Access form that you can double click on the results and it opens up another form "FRM_EDIT". I have about 5 computers that use the same thing and haven't had any trouble. Recently we got two more PCs and neither of them do anything when you double click to open the next...

Forgive me if this creates a redundant thread on this topic but I am at my wits end. I have searched all over the internet and can't find a solution to my specific excel problem. On time cards where double time is after 12 hours per mon-sat and all day sunday, how can I create a function for this?

This is my first ever post. I have a spreadsheet that has a lot of check boxes in sets of two. When printed it is hard to tell what is checked. I have redone the sheet and replaced the check boxes with empty cells. I also have a VBA code that will enter a check mark when a cell is double...

Below is a piece of code from another thread where double clicking on a cell changes the cell to red. If you double click on the cell again it changes back to its original color format. I am looking to see if there is a way to add additional colors to the choices. For Example, the first double...

Cell A1 = 29.7% <code> Dim PROF As Double PROF = Range("A1").value Range("B1") = PROF </code> B1 = .30 I want B1 to = .297 :banghead::banghead::banghead::banghead:

Hi, I updated a macro so that it uses the IRR within vba rather than the IRR worksheet function. To test this compared the worksheet function vs. IRR function & notice that the vba function is erroring out & the worksheet function returns a real value. Why is this...

Hello, I'm setting up a tool that will help to forecast staffing required to handle call volumes and would like some feedback. I have shared the file through the link below. The excel sheet does contain Macros. I'll post them for review as well. Many thanks to anyone who is willing to look...

I'm looking for a formula that will double the same digit. In cell L6 I have digit 4 and need in cell S6 = 44. 1 = 11 2 = 22 3 = 33 etc... Thank you. Serge.

Hi, I am getting the error "overflow", when I assign a variable of type double a number >32,000. What is going on? dim guess as double guess = 73000 'no overflow error guess = 73 * 1000 'gets an overflow error I remember this error happening in the past.

Hi, I've made this code for one row, and want to repeat it for the next 200 rows or so. Any tips? Dim d As Double d = Range("H10").Value Range("H10") = d + Range("J10").Value d = Range("I10").Value Range("I10") = d + Range("K10").Value Range("J10").ClearContents Range("K10").ClearContents