remains

I already have a script that does most of the mumbo jumbo of what I need, however at the very end of that script, I want to add the part to rename part of some of my sheets to something else I have multiple template sheets and a master sheet within a workbook, those need to remain untouched...

I'm using code to place this formula in the column A of a spreadsheet. Usually the code will update itself for each row, however this formula remains the same for every row. Any ideas why? Range("A3:A" & LastRow).FormulaArray =...

Hello All... I have an example, which I can't find any example of VBA to get a solution. If I have a cell contents of: ACE-1D / F-R3. I'm trying to find code that will take away the "/F-R3" so just the "ACE-1D" remains. This is one example, the next cell may have ACI-5 / 19...and so on. So...

Hello, I have a formula that links a cell from another WB. The formula works fine but when I drag it down the column in order to link other cells it doesn't copy correctly. It actually copies identical without adding the next row as a reference. I know by placing a "$" in front of either letter...

I have never had this problem before, but when I type = followed by clicking on a cell in another worksheet, nothing happens. The = remains in the original cell with nothing following it. Both of my cells are formatted to be Number. Thank you!

Trying to use AND OR together. IF(AND(A1=5,B1=10)) OR IF(AND(A1=30,B1=10),A1,"") This obviously doesn't work. The OR is to allow a different choice for A1 but B1 remains the some. A1 is a 10 or 30 and B1 is constant. I need two variables for A1 to agree with B1 resulting in a TRUE

Hi, I want to edit a value in a certain cell. The situation goes like this; Case 1: Let's say the value is 7.0, so the value remains 7.0 Case 2: Let's say the value is 7.333 which is lesser than 7.5 but greater than 7.0, so the value is changed to 7.5. Case 3: Let's say the value is 7.5, so the...

I would like the formula, =HYPERLINK("#INDEX('Dec17'!$1:$1,(ROW(C2)-1)*8+36)",INDEX('Dec17'!$2:$2,(ROW(B2)-1)*8+38)), to work with the fill handle. When I drag it down the name updates, but the link remains the same. I need the C2 to change to C3, C4, etc... Any workarounds? Thanks!