#REF error for the first row

**robert_mim** · 10-04-2009, 05:40 PM

Hi,

When I execute this macro, I am getting #REF error on the first row after the column headers (AQ2:AS2)

Please Login or Register  to view this content.

Thanks in advance.

**robert_mim** · 10-04-2009, 06:54 PM

I will appreciate any help with this post. I have upcoming deadline and I am encountering this problem.

Thanks.

**trucker10** · 10-04-2009, 07:03 PM

I do not understand what this macro to do

I do the same with tis macro

Please Login or Register  to view this content.

post your workbook for more details

**robert_mim** · 10-04-2009, 07:32 PM

Trucker10 thank you for your help. The file is too big for me to upload but here is what the macro is doing.

It is going to column A of the cases tab and takes the first value so if I used the excel sheet you attached (tst.xls) as an example, it will take the first value which is 1 then it pastes to "Pres Gen" tab I2 then there is another macro that runs after the pasting to I2 and it produces three values at I18:K18

This macro then copies those three values and pastes to CASES (AQ:AS). It keeps doing that for all rows starting with CASES(A2).

I hope this helps. I used the macro recording that is why my code is too long.

**trucker10** · 10-04-2009, 09:32 PM

Originally Posted by robert_mim

.

It is going to column A of the cases tab and takes the first value so if I used the excel sheet you attached (tst.xls) as an example, it will take the first value which is 1 then it pastes to "Pres Gen" tab I2 then there is another macro that runs after the pasting to I2 and it produces three values at I18:K18 .

I see no other macro .

This macro then copies those three values and pastes to CASES (AQ:AS). It keeps doing that for all rows starting with CASES(A2).

you can try the following, call your other macro , or separate the macros . Run the first macro copy and paste range A to I2 , after run ( call ) the second macro for the range I18:K18 to the sheet CASES ( AQ:As)