How to select cell but exclude first 2 row?

Hi, i'm quite noob at VBA. Only know the basic. I am writing a code where the entirerow will become bold wherever i select. HOwever, i discover that i need to unbold it when i change selection, if not, the entire sheet will become bold sooner or later. Hence i add it the code to unbold. However, my header (Row 1:2) which is suppose to be bold become unbold. What should i do to exclude Row 1 and Row 2 when i unbold?

Is there a better way to do this other than my method as below??

Please Login or Register  to view this content.

try this:

Please Login or Register  to view this content.

Originally Posted by ikboy

try this:

Please Login or Register  to view this content.

Hi, thanks it work. BUt just curious, does Usedrange = A1, den offset 2 mean row 1 and row 2 selected?

Try this you will easy understand:

Please Login or Register  to view this content.

Originally Posted by ikboy

Try this you will easy understand:

Please Login or Register  to view this content.

Hi, i tried, but it only select A3. Not the entire Row3, if thats the case, then
[code]
ActiveSheet.UsedRange.Offset(2).Font.Bold = False
[code/]

wont that mean only A3 become unbold?

You try to type some words to other cell then you will know...

@LJMetzger
Your code is rigorous, thanks.