Hi I am trying to use resize to make a range, and I want to use cells in my excel sheet to determine the resize value. Everything works fine for a positive resize (to the right or down). But I cant get it to work for a negative resize. What is the issue with my code?
This Works
This Doesn't
Please Login or Register to view this content.
Please Login or Register to view this content.
Who needs a life when you have Excel.
Hello TheMechEngineer,
As you have discovered, Resize only uses positive values. To go in a "negative" direction use Offset.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi,
as Mr. Leith mentioned:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks