So for each column i have to convert, i have a separate block. But the problem is, the files i need to run this macro for might have varying number of columns. The full macro i currently have does this for 111 columns. But if a file has less than 111 columns, the execution will stop halfway.
Can i do something like this instead?
1. Execute the block once,
2. Go to the next column,
3. If the first cell of the selected column has a value, continue the loop,
4. If not, go to next,
Thanks in advance!
PS: I really don't know about the terminology. I hope it's okay.