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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 18, 2014 at 10:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 18, 2014 at 10:50 AM
Related:
- Help to debug this sentence for me please ?
- [Dcc32 fatal error] f2039 could not create output file '.\win32\debug\project1.exe' - Guide
- Ck3 debug mode - Guide
- Usb debug tool - Download - Other
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 18, 2014 at 10:50 AM
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:
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
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
