I have the following formula in cell A13 IF(AND(H6>0,J8<-0.02,L6>-0.02),"MANAGEMENT SIGN-OFF IS NEEDED",""). If the value of J8 is -.01 the true statement appears but -.01 is not less than -.02. I know it has to do with comparing double negatives. The problem is sometime the result in J8...
Hello, I have the following code that I got with the help of this wonderful forum. I have modified a little but it is not working. Would it be possible to get your help?
Private Sub PicToSheet1(picControl, sht As Worksheet)
Dim PCAR As String
CAR = Me.TextBox1.Value
Dim p As String...
It has been a few years since I have really wrote any substantial amount of macros. This one is a few years old and I am trying to identify the issue and feel like it should be coming to me easier. I am hoping someone else with a little better knowledge base might be able to identify it...
Michael M (thank you) wrote the original code for me and I'm trying to make a change
I want to replace a deleted formula in column C when I double click in a cell. (See formula below)
If Not Intersect(Target, Range("c:c")) Is Nothing Then
Target.Formula = "=IF(BS$2=""Fixture...
For now, I go to print, select entire workbook, choose double sided, next page, rinse and repeat. The problem is I have 50 pages to do, is there a way to print the entire workbook double sided automatically?
I entered 1:00 and then 2:00 in cells B2 and B3, then in B4, I used = sum(B2,B3).
so far so good, then I highlight cells B2 and B3 and changed the format to "Text"...
I highlight cells A1:A3 and changed the format to Text. Then I entered time
They are all aligned to the left. So far so good. Then I highlighted them again and changed the format to Time.
Nothing changed!!. What I needed to do is to double click on...
I have this value (95551092 - ) in the activecell and I would like to add whatever value is in cell A50.
I do have the following code which adds the value but it deletes the spaces and then moves the hyphen in front of the numbers.
Dim d As Double
d = ActiveCell.Value...
I'm trying to create a macro in Excel that takes in a list of parameters, and I'm having trouble remembering the order to enter the parameters.
Functions defined in excel show the parameter such as = PV(rate, nper, pmt, [fv], [type])
How can I create my Macro to output the name of parameters...
I have a cell D4 which has value = 40:03:28
The value is aligned to the right side of the cell, which gives me an impression it is a number, right? When I one click (select) that cell. I see the following:
cell value = 40:03:28
Formula bar = 40:03:28
Home tab-->Number group --> I see...
How would we go about a top of column code where in this case its row 4 ?
As opposed to multiple codes have just one code.
I have row 4 frozen so always seen.
I have row 5 hidden so never seen
So maybe double click the coloum header cell in question to be taken to the top.
So i am in...
I have a long list of date that populates columns A:F
Can I have help with code that will simply delete the data held on that particular row through columns A:F
For example if cell A16 is double clicked then A16:F16 id deleted and the remaining rows beneath are all moved up to fill...
My data set is like this:
What I want to do is to run double sorts in VBA...
I need to calculate the points in the lower table as per the numbers in the top table:
So, Emma's points for interviews needs to be worked out 4 interviews, but as she is 2 interviews higher than the average the 2 above are worth double so 2*10 plus 2*20 - is this possible?
Hi, hope someone can help with this. I have listbox1 that has multiple items. I would like to select an item by double clicking the selected item and open a file. I have the path of where the file is so just need the code when double clicking the selection.
The following RoundtoUp code is failing in few specific cases as compared with Excel RoundUp:
Public Function RoundtoUp( _
ByVal myNum As Double, _
Optional ByVal myFac As Double = 1#) As Double
RoundtoUp = (Fix(myNum * CDec(10# ^ myFac)) + IIf(myNum = Fix(myNum * CDec(10#...
The following code works fine when the row that I have double clicked on contains data but it does not work if the row is blank, ie the code breaks at “Target.Offset(, -25).Resize(, 25).SpecialCells(xlCellTypeConstants).ClearContents”
So what I would like to know is it possible for the code...
I'm gonna search for Country Code for the criteria below:
I do not know how to use neither double vlookup nor index-match.
Can You please create both formulas and explain shortly how it works? Thx in advance. ;)