referance

I want to be able to double click a cell and then insert a row under the clicked cell that copies the formula from the above locked cells. When the sheet is unprotected, the code works fine. But when I try and the sheet is protected I get the error below. Is there a work around?

Hi, Not super familiar with the platform, but trying my best. This instance is referring to google sheets, but excel and sheets seem to be pretty similar. I am trying to reference data from multiple sheets into a master summary sheet. I started with just referencing the sheets and the cell...

Hi everyone. I don't understand why my VBA coding is still coming out with the R1C1 reference when I deselected it in my options. I am using Excel 2016. This system is supported remotely. Can that cause my options to be ignored? I'm hoping somebody has maybe experienced the same issue and...

current =COUNTIF(F:F,">1") need =COUNTIF(6,">1") thanks for looking Ross

So I have database using lot's of VLOOKUP, but they all refer to the same array ,where new column needs to be inserted in the middle of array. The array in formula moves, but columns remain the same. Hence it pulls data from the wrong place now. Is there a way to basically add 1 to every col in...

Hi guys I am trying to do a backup spreadsheet for all the devices at work (each device has 32 "nodes" in them so its one sheet per device) I have got everything working on each sheet (expiry dates, filters macros etc) but I am trying to set up one front "Status"page that shows you if work...

Dear All, the problem is when i put the below formula on offset function, the formula doesn't work =OFFSET(RIGHT(TEXT(FORMULATEXT(AB19),""),(LEN(TEXT(FORMULATEXT(AB19),""))-2)),2,3) the following formula that generate cell reference from Excel formula and it work perfect without Offset...

I'm having problems altering the value of a single cell on a sheet that I am not currently working in. Here is my code. Sub Button1_Click() Dim ws As Worksheet Dim hold As Integer Worksheets("L1-DIM").Copy _ Before:=ActiveWorkbook.Sheets("L1-DIM") Set ws =...

Hello all; I'm still learning advanced excel functions, so I really appreciate any help provided! I hope my terminology is correct too: If I have a value in cell A1, can I use that value as a variable to target an file for opening? Say I have a .doc saved in a job number file numbered 1001...

I've coded myself into a corner with this one The original code works beautifully as it searches my worksheet, finds predefined header name via Array("headername1", etc) and uses it to reference the Column letter("A") it's found at. It makes my sheet dynamic in that I can make changes with...

Hi everyone, I need some help filtering a table using VBA, please. So I have my search criteria in cell A1 words like: "clean","materials" etc In cell A2 I have a value that refers to my table header ex : A20, B20, C20 or D20 I want the code to look for the variable in cells A1 & A2 and...

Hi everyone! I am trying to write some code to filter a table A20 to F10000, table header is on row 20 I am trying to do the following: I have the the criteria in cell A19 , and the column witch needs to be filtered in cell E17 So for example in E17 I have "A20" and in A19 I have the word...