Hi all, how you doing
i 'm new to the VBA world and in this forum and I would like to ask for your help, of course if you can.
I created a "Sub" that should do the following procedure:
1. Detect the last active row in column “A” of my spreadsheet;
2. Still in this row, move the cursor to the column “Y”;
3. Enter in a "Do While Loop" to row 13 where:
It will establish an "IF" and check row by row in column “Y” if the “z” condition is True or False. If false it goes up to the next row before the last to the next analysis. If it is true:
i. Still on the row, the cursor will select the range from column 34 to 36 and will do a "Selection.FillRight", to expand the formulas and formatting;
ii. Then the same thing between columns 39 to 41;
iii. Then the same thing between columns 44 through 46;
iv. Then the same thing between columns 49 to 51;
4. Enter Loop Finishing procedure on line 13.
I made this VBA, but I don't understand why it isn't working.
Below is the attached spreadsheet if you want to analyze:
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
Bookmarks