I am having trouble with one line of this code that I can't figure out how to write correctly. I have set the range, but I need to offset by 10 rows up. My code fails at set rng. Here is what I have so far
Please Login or Register to view this content.
Last edited by sammar12; 05-16-2009 at 06:10 PM.
If the range starts in A7, you can't offset it 10 rows up.
Please change your code tags from HTML to CODE.
Entia non sunt multiplicanda sine necessitate
Could you suggest a method to get around this?
Probably, if I knew what you were trying to do. Post a workbook and explain in context.
Attached is a sample workbook of a similiar situation. This is a list of available products. Monthly the number of products can increase or decrease. I like to generate a sell sheet by item # for our sales people and alphabetical. Therefore I would like to set the range (in this example only through column c, but my actual book is through column Q). Once the range is set, I would like to sort based on Column c, however I would like to leave the last 10 items always at the bottom of the workbook.
Ah, the clarity of an example.
Please Login or Register to view this content.
Worked like a charm. I will mark this solved. Thank you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks