vba copy to cell with row number variable (like INDIRECT)

[Dorado99]

Hi there - just a newbie to VBA - use Indirect often but struggling with the VBA equivalent.
I want to copy value in a cell(A3) to another cell column F with the row number of which is held in cell D5.
VBA not impress with my effort as follows'-

Range("A3").Value = Range("F" & D5).Value

Error - "Method range of object - Global failed"

any assistance appreciated
cheers
Chris

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[BMV]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Dorado99]

Thanks Leo - so quick & easy - Hopefully I will improve with time - I'm smiling = Chris

[Dorado99]

Thanks BMV - so very quick - it's making me smile again - many thanks - Chris

[Dorado99]

Hi BVM - how would the syntax change if copying a range(A3:A7) to a range(D5:D9) ?
Hope you can help.
cheers Chris

[Dorado99]

Hi Leo - how would the syntax change if copying a range(A3:A7) to a range(D5:D9) ?
Hope you can help.
cheers Chris