I need a VBA code that will select just data. Right now when I try and select just cells with numbers, the code also selects the cells with formulas too. Also the fact the data is horizontal and not vertical, doesn't help either. But this is the set up. I a going to say the code should be dynamic in that the code will adjust as I add more data. I hope this is clear enough. If it isn't, at least it's a start.
Mr Excel 1.xlsx | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | date | Price 1 | Price 2 | Price 3 | Price 4 | Price 5 | date | Price 1 | Price 2 | Price 3 | Price 4 | Price 5 | |||
2 | Mar-16 | 10 | 14 | 18 | Mar-16 | 10 | 14 | 18 | |||||||
3 | Jun-16 | 11 | 15 | 19 | Jun-16 | 11 | 15 | 19 | |||||||
4 | Sep-16 | 12 | 16 | 20 | Sep-16 | 12 | 16 | 20 | |||||||
5 | Dec-16 | 13 | 17 | 21 | Dec-16 | 13 | 17 | 21 | |||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A2:F5 | A2 | =IF(H2="","",H2) |