VBA Express : Excel - Find First or Last Populated Row in a sheet
Integrating the search process for first useful and last useful rows is relatively easy to do; but why repeat the coding for each macro when the method is probably find ?non-blank? rows each time and a simple function, once written, can be used again and again
Count last row in active cell using VBA.
And if you read my comment above (I'll repost it here), I actually did quite clearly explain why it did not work: A more detailed explanation of what I require: Column A Header Value Value Value Value (blank) (blank) ..
I think I'll go with the Find function and your suggestion of changing the 'After' argument to the last cell (and yes, you're right to be picky - I should qualify the counts with the worksheet name) as it seems to do everything I want, and it calculates them in the blink of an eye. Up till now I had just used the code above which I ripped from somewhere on the internet (like this site) without understanding the components of the Find function
VBA Excel: Finding the last row of a worksheet (Part 1) - New Horizons Learning Centres Australia
So if you start on a blank cell, you will move to the next non-blank cell in that direction (or to the end of the sheet if there is nothing in that direction). With control arrows, if you know that there is a column in your data that always has data in it (no blank cells in the middle), then you can assume that by starting with the selection at the top of that row and clicking Ctrl+Down Arrow, you will end up at the bottom of the list
Use VBA to find last cell with data in a row
How can I set excel to find the last data-filled cell in a row, and how can I then use that information to set the range for my chart? I don't really have any code so far, as I'm not sure how to start this
excel - Error in finding last used cell in VBA - Stack Overflow
So if for example you enter something in B3 and something else in H8 and then later on delete the contents of H8, pressing Ctrl + End will still take you to H8 cell. This criterion usually produces unexpected results, but it may also be intentionally exploited (less often, surely), e.g., to highlight or print specific regions, which may eventually have no data
Find the last cell address using vba excel - Stack Overflow
Why do you think the existing code samples are inapplicable? Finding the row number of the last used cell in a column sounds like exactly what you need. I was wondering what code would work so that I can either find the row number and somehow tie it in with my range code so that it will equal "A" + lastrownumber? OR if there is code that will provide the column and row number together? If I have missed the link to the correct answer a simple link will do as well and I apologize for the post and your time
No comments:
Post a Comment