LinkBack URL
About LinkBacks
I have the following code. Is there any way to select a range once the last cell with data is found. I would like to be able to select whatever cell in column A is selected with the code below through E2.
Range("A65536").End(xlUp).Select
I have the following code. Is there any way to select a range once the last cell with data is found. I would like to be able to select whatever cell in column A is selected with the code below through E2.
Range("A65536").End(xlUp).Select
Last edited by billykiller05; 10-20-2009 at 03:51 PM.
Do you mean
Range(Cells(Rows.Count,"A").End(xlUp),Cells(2,"E")).Select
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Man that worked Awesome. Is there a way to add a popup calendar to a user form? I have tried the Calendar 12.0 but I would like a popup calendar.
Different question - new thread please.
Ok no problem. Thank you so much for your help on this issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks