Re: Move down 1 cell after going to the end of my data.
Selection.End(xlDown)(2, 1).Select
An Offset feature (2=nextrow,1=same column). (1, 1) would be no offset.
Mike F
"Pendelfin" <Pendelfin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C1A5EE06-7CA2-42F7-8F5F-01E1AD64D979@xxxxxxxxxxxxxxxx
Please can someone let me know what I should enter to move down to the
next
cell in my macro,instead of it moving to a specific cell. I recorded the
following, but instead of going to cell A15 i want to go down to the next
cell.
Many Thanks in advance.
Selection.End(xlDown).Select
Range("A15").Select
.
Relevant Pages
- RE: VLOOKUP Function
... "Mike H" wrote: ... With the range correct theres nothing wrong with the formula so if it's ... Copy your value from L2 andpaste it into a cell in 'Charges'. ... You have a single column array in your vlookup 'CHARGES'!A$1:A$250 ...
(microsoft.public.excel.misc) - RE: VLOOKUP Function
... "Mike H" wrote: ... With the range correct theres nothing wrong with the formula so if it's ... Copy your value from L2 andpaste it into a cell in 'Charges'. ... You have a single column array in your vlookup 'CHARGES'!A$1:A$250 ...
(microsoft.public.excel.misc) - RE: Current Time
... Hi Mike, its me again, wonder if you can help me again. ... in cell B1 I have the Time ... Double click 'ThisWorkbook' in VB editor and paste ... Private Sub Workbook_Open ...
(microsoft.public.excel.misc) - RE: Last cell in active row--I know, Im sorry
... Thank you so much for sticking with this Mike. ... then used xlToLeft to select the last cell in the row. ... Sub LastCol() ... "Greg Snidow" wrote: ...
(microsoft.public.excel.programming) - Re: Link comment boxes based on different cell values
... Mike wrote: ... "Dave Peterson" wrote: ... each cell and where appropiate create a comment field of the right ... link to the other sheet would be fantastic, however I need to keep the state ...
(microsoft.public.excel.programming) |
|
