problem with putting borders around cells with macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi;

I have a two sheet workbook where one sheet is called "Data" and the other
"Results". Data holds my information to search on while the top part of
results holds the cells whose values will be searched for. This is called the
criteria range. The bottom part of Results is the area where any hits will
appear.

I've noticed that some of the criteria range cell borders get removed after
searches. I've tried the following code to regenerate the borders:

CritRng = "B3:K5"
....
Worksheets("Results").Range(CritRng).BorderAround _
Weight:=xlThin

However, some of the borders in the specified range do not regenerate. Any
ideas?
 
Works OK here. Do you have any code after this which affects the borders in
some way (eg clears borders, pastes data from cells without broders etc)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Border formatting row of cells 22
advanced filter macro to locate values via multiple criteria 1
Error with Borders of a Range 1
Border cells with less code? 4
Advancedfilter returning all rows instead of ones that match crit 8
Counting Bordered Cells 5
blank value for row and column in msgbox 3

Back
Top