Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Run time Error'1004'

ShalakaShalaka Member Posts: 3
I want to copy "=OFFSET(reference,rows,cols,height,width)" this formula in one sheet, for all the rows of 1 column.

i wrote code for that as follow with proper range and values.

For n = 2 To row_cntZ
ThisWorkbook.Sheets("ZERO_IP").Cells(n, 4).Value = "=" & "offset($A$1,MATCH(C" & n & ",$A$2" & row_cntP & ",0),1)"
Next n

But after running the code i m getting Error Message
" Run time Error'1004':
Application-defined or Object-defined Error"

Can anyone help me for this problem, Please?

Thanks in advance....

Sign In or Register to comment.