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 Contributor Last seen December 27, 2022 - Aug 18, 2014 at 10:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Aug 18, 2014 at 10:50 AM
Related:
- Help to debug this sentence for me please ?
- Ck3 debug mode - Guide
- [Dcc32 fatal error] f2039 could not create output file '.\win32\debug\project1.exe' - Guide
- Usb debug apk - Download - Other
- Flash player debug download - Download - Other
- Which two sentences correctly describe the use of formulas in performing calculations in spreadsheets? all formulas written for a spreadsheet must follow certain rules, which we call syntax. when creating a formula in a spreadsheet, always start with an if statement. basic statements include numeric values and operators. if there are multiple operators, then the order of precedence starts with exponents. parentheses are used to isolate certain parts of the expression from the other parts. operations in parentheses are completed after the rest of the formula is evaluated. - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
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