Find End in Undefined Range Select Range Trim
Hello,
I'm working with .CSV worksheet that arrives already 'Text to Colmuns....'
The data is delimited resulting in various data positioning.
Can someone help with macro that will
1) Find 'END CELL' In sheet given random placement of data
2) Select Range.A1: 'END CELL'
3) Trim all cells within the Range
I've searched through the posted solutions on the subject and tried various
combinations of posts but having no luck
Many thanks / Happy Holidays
Steven
|