Run-Time Error ‘1004’: Method ‘Range’ of object ‘_global’ failed?
I have a macro that is supposed to take a cell (starting with J8), perform the text to columns function (placing the data in 2 columns starting with J8) and then go down two rows (to J10) and performs the same function.
It is intended to continue this process until it reaches an empty cell, but I’m getting this error and can’t figure out why. Any tips or advice would be greatly appreciated. Thanks!
I have a macro that is supposed to take a cell (starting with J8), perform the text to columns function (placing the data in 2 columns starting with J8) and then go down two rows (to J10) and performs the same function.It is intended to continue this process until it reaches an empty cell, but I’m getting this error and can’t figure out why. Any tips or advice would be greatly appreciated. Thanks! Read More