Hiya!
I have a macro that imports a set of data from a .txt report each day.
But I require the data to have all borders around the cells of data.
The only problem is that the data changes each day, so sometimes it could be 34 rows x 7 columns and other days it could be 102 rows x 7 columns. (just as an example)
How would I write it into the macro to put borders around all cells containing data??
I am so stuck!!
Thank you so so much in advance.
I have a macro that imports a set of data from a .txt report each day.
But I require the data to have all borders around the cells of data.
The only problem is that the data changes each day, so sometimes it could be 34 rows x 7 columns and other days it could be 102 rows x 7 columns. (just as an example)
How would I write it into the macro to put borders around all cells containing data??
I am so stuck!!
Thank you so so much in advance.