fine

Hi, I am trying to sum up 3 cells. This issue is I want to have them sum when specific text is added into two other cells. Here is the formula I have tried. =IF($AJ6="M",SUM($AG6:$AH6),IF($AJ6="B",SUM($AF6-($AF6*0.2), $AG6:$AH6), IF(AND(AI6="P",$AI6="N",$AI6="B",$AJ6="M"), SUM($AG6:$AH6,500)...

I have a very simple VBA sub which is intended to underline a worksheet at each page break when printed. The total length of the worksheet is 3574 rows. The sub works fine down to row number 1477 but then gives an error message "subscript out of range". I have used this in the past on Excel 2007...

I am a novice and looking for a VBA code to copy all sentences of matching string based on the given keys that match up to five characters in the output sheet (as below). My actual data is a few thousand rows long and is in the sheet named "string". My key data is a few hundred and is in the...

I have one particular spreadsheet which I was using fine yesterday, but today it opens blank. I've searched on-line for solutions, but they all appear to be implying fixes for Excel will not open at all. Many other workbooks open perfectly fine, just not this one. This workbook is not...

Hi I want to save as a workbook so I wrote the code below. It works fine, it gives me the window below which is save as window but when I click No (so I can pick macro enable file), I get this error message I know I am not following the syntax of Save as, but it used to work just fine...

Hi I tried to use while condition .... end while as per https://tinyurl.com/y7jnl7xe instruction but did not work but while condition ..... wend worked fine - https://tinyurl.com/y98mz7o3 so my question, which syntax is correct? Thank you.

Hello All - Thanks so much for any ideas you might have on this: I am trying to combine the following statements, each of which seem to work fine on its own, into one statement. Have googled, have searched here - surely I am missing something fundamental. Many thanks for suggestions...

For some reason my immediate window only displays the last half of my output. It's only a couple hundred lines at most. I ran a for loop from 1 to 10000 and it worked just fine. Anyone know what the problem is?

Hi Everyone, Hope you are dong fine. I have an Excel sheet where there are three drop downs with input 1 and blank in each drop down from G1 to I1 Initially all cells are blank. If user selects 1 in one of the cells then excel should be able to restrict data input in other 2 cells. I have...

Hi all im creating a chart for the 50 US states, what i would like to do is have some states match up and others wont, example , CA to NY is fine but NY to CA is bad , CA to AZ is fine and AZ to CA is fine the NY to AZ is bad and AZ to NY is bad

Hello Friends, I am trying to Vlookup from one workbook to another. Problem i am having is when i use a named range in the Vlookup - it works fine. But when a dynamic name range is used in Vlookup then its giving #REF! & to make the Vlookup formula work i have to open the mother source file...

Hello, I have this formula : Selection.AutoFilter Field:=2, Criteria1:="<>" & Worksheets("Temp").Range("B2:B" & LastRowKTemp).Value I can not make it work. If i hard code the criteria it is fine. The value of the LastRowKTemp is 7, i checked that; It's fine. When i use that formula, it is...

Hi all I've worked 2 hours trying to determine the problem with the following simple code: Sheet1.Rows(3).insert 'Insert a new row at Row3 When I run it on a blank workbook/worksheet it works just fine, however when I run it on a workbook/worksheet with data it just passes (in single...

I am doing a price change using a serial number of sorts for my lookup value. This file has over 4,000 lines and they all work just fine except for 3. I have seen this before but usually when my lookup value is a number only (without alpha). I usually work-around by adding an "x" before or...

Hi all, I have the following formula that works for any number over=IF(C3&I3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(($BJ$3:$BJ$5002=C3)*($BK$3:$BK$5002=I3)),$BV$3:$BV$5002),"Backorder")) This seems to work fine but not when BV returns 458429 Any ideas why? Thanks

I have a workbook with macros. The workbook has a signature on it that locks it down from being editable. That's fine. The problem is that most of my macros works fine except for the ones that do a range().Find and I don't know why that fails. Has anyone seen this and gotten around it before...

No biggie here. While some of my macros are running, I have ScreenUpdating=false . I update the progress for the user by changing the Caption on a Command Button and then turn on Updating and then turn it off. It works just fine. I was wondering, however, if there was a way around turning...

Yesterday, everything worked fine. Today, now I get the same error on every control I select. I also tried a completely separate workbook (nothing in common with the first except both use VBA) and got the same error! :confused: The only change I made yesterday to bothwork books was adding in...

Hi can anyone help? I am copying data from "AJ2:AS & lRowAJ" to "N2:W & lRowAJ" and "X2:AG & lRowAJ" If I use the following line it copies fine [CODE .Range("AJ2:AS" & lRowAJ).Copy .Range("N2:W" & lRowAJ, "X2:AG" & lRowAJ).PasteSpecial...

Hi All I am using the following formula to calculate the last quarter end date x = DateSerial(Year(Date), Int((Month(Date) - 4) / 3) * 3 + 4, 0) This currently returns 30/06/2018 When try to use this in the below formula I am not getting the correct value. I have taken the other conditions...