Gurus,
below code is what I learnt prior for multiple columns manipulation within a table:
now the thing is that I need to locate a specific cell in a table and delete all the columns left of the cell.
Currently Im using .find. column to find out the number of columns.
Since .find.column renders an absolute number of columns based off the specific cell, I have encountered 2 problems:
1. What I learnt uses letter reference for columns. How do I 'convert' the column number to letters or is there an alternative approach?
2. if I want to keep the columns to the left outside of the table, how do I do it if .find.column emits an absolute column number?
Right now my solution is to loop .columns(1).delete for find.column times
below code is what I learnt prior for multiple columns manipulation within a table:
VBA Code:
Sheets("a").ListObjects("abc").Range.Columns("A:B").SelectCurrently Im using .find. column to find out the number of columns.
Since .find.column renders an absolute number of columns based off the specific cell, I have encountered 2 problems:
1. What I learnt uses letter reference for columns. How do I 'convert' the column number to letters or is there an alternative approach?
2. if I want to keep the columns to the left outside of the table, how do I do it if .find.column emits an absolute column number?
Right now my solution is to loop .columns(1).delete for find.column times
Last edited:
