Excel VBA to know what kind of border it is

[JohnSeito]

Does any know of excel code to know what know what kind of border it is. I converted a pdf file and now the data are on excel and there are borders and it looks to me like it is border with thickness of medium but when I run a code I produced and mark X to the column next to it to show that it is that border it gave me X on all the rows and so the medium thick border is excel grid without any borders.

So if anyone could show a code example of what kind of border does an excel has then let me know. thanks.

 

[JohnSeito]

I don't see anyway around this as well.

The reason why I would like if this could be done is because I format and move data around a spreadsheet a lot. One of the ways to move it is using the formula = x2 etc, then copy paste special value then delete the data that was moved from. I do this very frequently, like 20 times or more in a format. So if I have to unfiltered every time to move it, I lose my place and it takes longer time.

A loop through Range("B:B").SpecialCells(xlCellTypeVisible) is the only solution that I can see.

I don't think a loop macro would be effective either, what do you think or suggest?

 

[mikerickson]

One way might be to copy/pasteSepecialValues the data range before filtering. That way copy/paste could be used to move the data from here to there.

A macro to write the proper formulas into the data range (to be run after everything has been moved, but before new data arrives) could be written to restore the formulas when needed.

 

[JohnSeito]

One way might be to copy/pasteSepecialValues the data range before filtering. That way copy/paste could be used to move the data from here to there.

Can't because I only want the filter data to be moved over and the data that was moved from to be deleted.

A macro to write the proper formulas into the data range (to be run after everything has been moved, but before new data arrives) could be written to restore the formulas when needed.

not sure what you mean by this.