QuietRiot
Well-known Member
- Joined
- May 18, 2007
- Messages
- 1,079
- Office Version
- 365
- 2021
- Platform
- Windows
- MacOS
right now I use one worksheet that contains 2 companys data.
say columnas A to F are for company 1 and I to j for company 2
however the headers are not always in the same spot.
i want to build something that will find this. Im looking for code that will give me "A:F" and "I:J"
it will always start with A so it needs to look for the a blank then stop and say hey that means A:F then continue find the next filled cell and start from there until the next blank to get I:J
say columnas A to F are for company 1 and I to j for company 2
however the headers are not always in the same spot.
i want to build something that will find this. Im looking for code that will give me "A:F" and "I:J"
it will always start with A so it needs to look for the a blank then stop and say hey that means A:F then continue find the next filled cell and start from there until the next blank to get I:J