Goto Last Open Cell In Column D, Make It Equal To Cell G3

[NewToExcelGlenn]

[FONT=Calibri][SIZE=3][COLOR=#000000]Range("d" & Rows.Count).End(xlUp).Offset(1,0)= Range("g3")[/COLOR][/SIZE][/FONT]

Hello. Can anyone tell how to goto the last open cell in column D, and make that equal to cell g3. Cell G3 has a number in it?

Thank you.

 

[pike]

Hello,
what you have should work

Range("D" & Rows.Count).End(xlUp).Offset(1, 0).Value2 = Range("G3").Value2

Are there any merged cells?
same but different

Cells(Rows.Count, "D").End(xlUp).Offset(1, 0).Value2 = Range("g3").Value2

 

[NewToExcelGlenn]

Hello,
what you have should work

Range("D" & Rows.Count).End(xlUp).Offset(1, 0).Value2 = Range("G3").Value2

Are there any merged cells?
same but different

Cells(Rows.Count, "D").End(xlUp).Offset(1, 0).Value2 = Range("g3").Value2

That worked. It was the .Value ending that I didn't have.

Thank you very much for the help.

I too am an animal lover, and I'll certainly donate to RSPCA.

 

[pike]

Hi Glenn, even make a local donation