Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with putting borders around cells with macro
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? -- JJFJR |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with putting borders around cells with macro
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)? -- Ian -- "jjfjr" wrote in message ... 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? -- JJFJR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
taking numbers in vertical cells putting them in horizontal cells | Excel Worksheet Functions | |||
Borders printing problem | Excel Discussion (Misc queries) | |||
Problem Printing Borders | Setting up and Configuration of Excel | |||
Printing Borders Problem | Excel Discussion (Misc queries) | |||
Help required putting borders around cells. | Excel Programming |