hi,
after a paste action in the sheet how do you?
auto select A1 up to the last row in column C with data
then auto sort the selection based on column A
then auto save
hi,
after a paste action in the sheet how do you?
auto select A1 up to the last row in column C with data
then auto sort the selection based on column A
then auto save
try this
- assumes that the correct workbook is active
- assumes that there are no empty cells in the relevant range in column A
- amend sheet name "MyData"
Please Login or Register to view this content.
Last edited by kev_; 01-18-2017 at 09:45 AM.
Lazy version of the same code
Please Login or Register to view this content.
how do you trigger the macro select-sort-save after a paste action?
my list has no header should i just edit "Header:=xlYes" to "Header:=xlNo" ?
Add this line at the end of the Paste macro
Please Login or Register to view this content.
YESmy list has no header should i just edit "Header:=xlYes" to "Header:=xlNo" ?
got it thanks!
You are welcome
Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks