My macro consists of copying certain data from one worksheet to another. Pretty simple, yet I keep getting this message "Run-time error '1004': Method 'Range' of object'_Worksheet' failed"
This is the code, yet the BOLD is where it highlights:
'Locate last empty row in Master File
FinalRow = Source.Range("B8").End(xlDown).Row
'Loop for updating data
For x = 9 To FinalRow
Source.Range("B" & x).Copy
Target.Range("F" & NextRow).PasteSpecial xlPasteValues
Please help, I know it might be something very simple.