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:
- 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.
- Spreadsheet formula - Guide
- Square parentheses mac - Guide
- Formula to calculate vat in excel - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - 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
