Run time Error'1004'

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.

Howdy, Stranger!

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