Column Issue with Range

Thanks in advance for any help.

I'm doing some importing of excel data from one file to another. That works fine. My problem is that when I get the new data in I have to do some stuff to the data to clean it up. I first declare the variables below and set them

Please Login or Register  to view this content.

This tells me the last column and row with data. I now have to select the column after iLastCol because I have to put a formula into every row in that column. Currently iLastCol = 18 which lands on letter R.

I don't know how to set the Range proptery to allow to select column iLastCol + 1 down to row iLastRow?


Prior to me switching to using column numbers the VBA code looked like this

Please Login or Register  to view this content.

Thank You for your help

jerry8989

Read the Forum Rules & use Code tags in future.

I'm not sure why you are making the variables as Public and I would use Long insttead of Integer, in case the variables exceed the Integer's capacity.

Please Login or Register  to view this content.