Help to debug this sentence for me please ?

Closed
SherlynPeh Posts 8 Registration date Tuesday August 5, 2014 Status Member Last seen August 14, 2014 - Aug 14, 2014 at 11:42 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Aug 18, 2014 at 10:50 AM
Hi,
Is there any way I can debug the sentence highlighted in yellow ?
Thanks!

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Aug 18, 2014 at 10:50 AM
Hi Sherlyn,

So what I think you are trying to do is:
Copy the value from G5 from the "AMBS" sheet and paste it one cell below the active cell of the "fy2013" sheet.

Here is the code I would use:
Sub RunMe()
Dim xMember As String

Sheets("AMBS Masterlist 1314").Select
xMember = Range("G5").Value

Sheets("fy2013").Select
ActiveCell.Offset(1, 0) = xMember

End Sub


But to answer your question directly it is either:
ActiveCell.Offset(1, 0).Select
or
Range("B5").Offset(1, 0).Select

Depending if you want to go with the active cell or B5.

PS: Next time posting a code, paste the code in your message, select the entire code, look for the <> symbol above the message body and click on the arrow down, selecting Basic, for a clear view on the code.

Best regards,
Trowa
0