Macro to Delete Rows in Columns Based on Length of Column "A"

[rmmohan]

I currently have a macro that autofills the columns down based upon the length of column "A"
In the attached file that is in tab, "A>B"

But in some cases column "A" will be shorter than the other columns.
I then need the macro to delete the excess rows in column "B" through "C" in this example
This is shown in tab, "A<B"

I would then change this into an if statement so that no matter the circumstance, the macro could execute correctly.
But what I'm missing is a way to delete rows based upon the length of column "A"

I really appreciate any help!

Thanks in advance!!

[protonLeah]

Please Login or Register  to view this content.

[rmmohan]

In the actual file, the columns relying on column "A", are column C through column GR.
It's going to be really tedious to enter in a line for every column. And actually it won't let me enter that many repeating lines.
Is there a way to condense that part of the code?

Otherwise it's really great!

Thank you!!

[protonLeah]

Please Login or Register  to view this content.