works

Hey All, Quick question, I have some very basic code copying and pasting from one tab to another, however, for some reason, the Copy doesn't work, unless I'm looking at that tab. If I'm looking at another tab, nothing get's copied. But when I'm looking at the source tab, it works perfectly. Any...

Hi there I need to save the file as a new workbook (asking user to choose path) and within that file, remove all formulas. The code I am using to remove all formulas is: Sub All_Cells_In_All_WorkSheets_1() Dim sh As Worksheet Sheets("ImportNonCCB").Visible = True...

Hi All! Spent about 3 hours working on a spreadsheet here and officially at the end of my tether, so wondering if someone more talented can help me out! I have a Vlookup which is working absolutely fine half of the time, and randomly spits out a #N/A the other half. Lots of other formulas...

Hello, I'm having trouble with a formula considering the work as night shift. The formula works fine untill it reaches the AM values. I'll post a picture: the formulas I have in there are: C6 =(($F6>$G6)*MEDIAN(0,$G6-$H$5,MEDIAN($H$5,$F$5))+MAX(0,MIN($F$5,$G6+($F6>$G6))-MAX(1/4,$F6))) D6...

So I am using the below code to sort based on the parameters in order and it works except the very first status "ETOX" keeps going to the bottom instead of the top. I can change to descending but then the order is incorrect. What am I missing here? Sub SteriSort()' Sort by Steri Macro Call...

Can anyone advise why the below formula seems to include all blanks, and how I get around this please? (It works fine for every other month!) =SUMPRODUCT(1*(MONTH('Dev WIP'!$AC$2:$AC$1000)=1))

I have this code in a Worksheet Private Sub rowNumber = Columns("B").Find(Right(cboJump, 8), , xlValues, , xlRows, xlNext, , , False).Row It usually works... but sometimes goes to error Object Not Set It seems odd it's not consistent. has anyone any ideas? Thanks.

I have some code which works for me, but gives an Error 400 message to another remote user. MsgBox 1 ActiveSheet.Unprotect Password:="abc" MsgBox 2 Range("ShiftMonths").Copy 2 is the last message the user receives before the code fails. "ShiftMonths" is a range on the active...

So I have database that has an employee table/sheet "Employees" with three columns...EmployeeID, FirstName, LastName. Most of the data only uses EmployeeID...but I don't want users to have to remember employee IDs when using it. So, I use an ActiveX ComboBox to display the three columns and...

Good Day Mr. Excel users, I saw my colleagues doing this weird formula that I never seen. =VLOOKUP(E:E,reference!I:L,4,0) above lookup value refers to entire column E:E but assuming above formula in in row 2, it only uses E2 as reference and it works. Can someone please explain to me on why...

Hello all, I stumbled across a wonderful formula which works perfect, but the logic is beyond my comprehension, so I'm having difficulty adding one bit of additional criteria. In column H, I have a list of text strings, some of which are repeated...

Hi, I am learning how to use htm within .htmlbody. I pull a bunch of dynamic values and am wanting to make these bold. " PO Description: " & ""&Range("H" & (ActiveCell.Row)).Value&"&" & " " _ The "" works but the "" gives me an error. For some reason it refuses to accept my html coding. In...

Good morning everyone, I am looking for a little help with getting a hyperlink to work. I am attempting to use V & H look up functions to provide me a hyperlink to another worksheet that is contained inside the same workbook. I can get the look up function to work just fine, I am having trouble...

Hi. I have the below code which isn't working in VBA. The formula works perfectly as a formula placed manually in the cell but doesn't work as part of the macro. It seems to be the "" at the end of the formula which is confusing it. Please can somebody help? Sub FillEXTEND()...

If I run this code as a macro it works fine but put same code in for a command button and I get a Run-time error '1004': Select method of range class failed. Anyone help with a fix? This is where the debug stopped in the code: Private Sub CommandButton3_Click() ' ' DeleteInputData Macro '...

So i have a listbox connected to a "button" in my sheet that allows me to check off certain selections - it works great until i protect the sheet...how do i get it to run when the sheet is protected???

Hi, does anyone now if there is another IFS formula or something simular that works with excel 2013 or earlier. The below formula only works with the later versions. Thank you <tbody> A B C D E F G 2 3 < 1 MNTH 1-3 MNTH 3-6 MNTH 6-9 MNTH 9-12 MNTH 1 YR > 4...

Please could someone tell me why the Autofill destination does not work with single rows? i am using Range(“h2”).Autofill Destination:=Range(“H2:H” & last row) It works perfectly for multiple rows, but gives me an Autofill method of range class error if there’s only one row of data.

I am using the new Excel formula " TEXTJOIN" and works great however this formula only works on the new version of office 360. What formula can I replace this with on older version of Excel? Does anyone know? Thanks in advance. {=TEXTJOIN(",",0,IF(J20:J23>0,H20:H23,""))}

How would you rewrite this code Range("A10").End(xlDown).Offset(1, 0).Select so that it works on ANY column? Thanks for anyone's help. cr