Paste Special Error with Offset Formula

**aftabn10** · 11-26-2010, 06:49 AM

Hi, I have written some code in Excel VBA for a report that I have created but seem to have ran into some issues.

I have 2 sheets a form and a paste sheet, the code looks into the form sheet and copies the values in row 6 and then needs to paste this in the first available cell in row 3 (F3) but for some reason this pastes the data in F4 and i am not sure why this is.

If somebody could please help.

I have attached a sample workbook but the following is the code I have used.

Please Login or Register  to view this content.

Thanks in advance.

**StephenR** · 11-26-2010, 06:57 AM

Not quite sure, but does this help?

Please Login or Register  to view this content.

**aftabn10** · 11-26-2010, 07:14 AM

StephenR, thanks for this. Just wondering if i ran the code again would this then move onto the next row as there would already be data within cell F3 to L3?

Thanks once again for your help.

**StephenR** · 11-26-2010, 07:17 AM

It looks at the last used row in column A of paste sheet and pastes in F in the row below that. Not sure why you were using A. If everything is based on F then better to use that so change the RowCount line.