Get instant live expert help on I need help with vba offset value
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
To return the value of the cell D8, the formula should be OFFSET(A1,?,?)
Solved by S. L. in 26 mins
I have this formula which makes NX16 and NX17 have a value of 0.5 rather 1. I need to expand this to make NX14 and NX15 to also have a value of 0.5 but am stuck =SUMPRODUCT((OFFSET($A8,0,31*($A$3-1)+1,1,31)<>"")*(IF(OFFSET($A8,0,31*($A$3-1)+1,1,31)=$NX$16,0.5,IF(OFFSET($A8,0,31*($A$3-1)+1,1,31)=$NX$17,0.5,1))*(OFFSET($A$4,0,31*($A$3-1)+1,1,31))))
Solved by D. D. in 27 mins
i need assist with some vba coding Dim ws As Worksheet Dim irow As Long Set ws = Sheets("sheet1") irow = ws.Cells(ws.Rows.Count, 1).End(x1up).Offset(1, 0).Row The last line keeps coming out as an error?
Solved by I. H. in 14 mins
Excel VBA How do I resize a range of cells to remove the first two (left) columns in a range? Do I have to resize to Range.Columns.Count - 2 and then offset +2 columns, or is there another way to do it?
Solved by E. C. in 19 mins
vba vlookup help it half works but cant write a value.
Solved by G. D. in 13 mins