border around some cells

[KlausW]

Hi all Excel helpers

Someone who can help, I want to put border around some cells. If I write A9 in cell J6 and I3511 in cell J7, all cells between the 2 must have a border around also in the middle. It has to be flexible, so if I change the numbers in J6 and J7 the border has to change too.

All help will be appreciated.

Best regards

Klaus W

 

[bebo021999]

Dou you refer Conditional formatting, or VBA?

 

[KlausW]

Dou you refer Conditional formatting, or VBA?

VBA

 

[bebo021999]

Try:

Sub border()
Range(Cells(Range(Range("J6").Text).Row, Range(Range("J6").Text).Column), _
Cells(Range(Range("J7").Text).Row, Range(Range("J7").Text).Column)).Borders.LineStyle = xlContinuous
End Sub

 

[KlausW]

Try:

Sub border()
Range(Cells(Range(Range("J6").Text).Row, Range(Range("J6").Text).Column), _
Cells(Range(Range("J7").Text).Row, Range(Range("J7").Text).Column)).Borders.LineStyle = xlContinuous
End Sub

Great, thank you so much for that solution. It was just as it should be. Have a nice day. Many thanks KW