Variable Range - Set Rows AND Columns as variables
Hi guys,
i Need to have a variable range for selecting shapes in a specific range on my sheet.
My Code can already shift the range on any row (easy because of Number Format). But how can i set variables instead of column letters (like A or S in the example) to enable also a shift in columns.
Look in the attachment for further Explanation and a sample set to try your solution on.
Please Login or Register to view this content.
I appreciate any help.
Last edited by JonasBig2; 09-20-2018 at 04:45 AM.
Hi
Not so clear. Can you post a sample of your workbook ..
How would you like to store the variables of "A" and "S" .. in cells or in the code itself?
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
I explaned my attempt in the attachment. You can also try your solution on my created example in "Sample.xmls"
Do you mean something like that
Please Login or Register to view this content.
Yeah exactly but i Need to increment the letters in every Loop. Is there are alternativ for writing only numbers to select a Range.
Thats what i found on the Internet, but it didnt work in my example:
Only numbers for selecting a shape. So easy to incrementPlease Login or Register to view this content.
Try this version
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