mikerickson,
I have done something like this once in the past, where I converted a file from PDF onto excel and it has all these borders.
I wrote a code to say that if this cell has a border mark X to that row the column next to it. The last time I remember it works and I only did it once and I lost that piece of code.
Now I was to do it again with a remake of that code and it just doesn't work.
example of the most recent code I made:
Code:
x = 2
Do
If Cells(x, "h").Borders(xlEdgeBottom).Weight = xlthin Then
'xlMedium Then
Cells(x, "I") = "x"
End If
x = x + 1
Loop While x < 3000
this code does not work properly it mark X to all rows even if they didn't have border and just plain excel grid, and if i changed it to xlmedium which is what the borders look like this code will not mark anything.
Is is possible that there are odd characters coming from the PDF that look like a border?
on the pdf it looks like borders, and on excel it does too. So if it is odd charcters, I don't know but from an educated guess probably not, but if you know a code that can read that cell and tell what it is, then we could find out.
Might this be an issue of the cell's contents rather than its border?
if there is a code that can read that cell contents and tell what it is, if it's border or not or something else that would help answer the question. As I have said that I have done this once in the past and it work, but I don't know why it didn't work again, i don't remember the exact code I have use but i know it reads borders.