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
Set Left = A.Resize(1, Range("B1").Value)
Set Left = A.Resize(1, -Range("B1").Value)
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:
Set left = (Cells(1, 5).Offset(0, -Range("B1").Value).Resize(1, Range("B1").Value))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
TheMechEngineer 
Register To Reply
Bookmarks