Hi All,
I am hoping someone will be able to come up with a handy way to insert the cell property "font" into an array so i can check whether it is a strikethrough or not without having to continuously call the sheet.
Basically I am looking for something similar to this:
Code
FontTypeArray() = Sheet1.Range(Sheet1.Cells(17, CableLengthCol), Sheet1.Cells(LastRow, CableLengthCol)).Font
I've tried everything from setting the array to an object, font, ect. I know you can set a variable to the font type by going
But this does not work for arrays. If i have to loop through the array anyways I will just leave my code as is and continually check the sheet for font type. I was just trying to minimize the number of sheet calls to speed the code up significantly, as I am in the realm of 10000 lines of data.
Cheers,