Range is not selecting what I want

[holy_eti]

Hi, I have a small problem with my range option. I am trying to run mycode and it has to format some precise cells. My code seems to be good but when I run it, instead of selecting the range that I want, my macro is selecting the whole sheets so it detroys what I did previously..
Could someone help me please? Thanks

Here's my code :

For i = 5 To 12
    ThisWorkbook.Sheets(i).Activate


    ThisWorkbook.Sheets(i).Range("J6:J300").Select
    Selection.NumberFormat = "m/d/yyyy"
    ThisWorkbook.Sheets(i).Range("Q6:Q300").Select
    Selection.NumberFormat = "m/d/yyyy"
    ThisWorkbook.Sheets(i).Range("B6:B300").NumberFormat = "General"
Next i

 

[Fluff]

Sounds like you might have merged cells.
Try

For i = 5 To 12
    ThisWorkbook.Sheets(i).Range("J6:J300").NumberFormat = "m/d/yyyy"
    ThisWorkbook.Sheets(i).Range("Q6:Q300").NumberFormat = "m/d/yyyy"
    ThisWorkbook.Sheets(i).Range("B6:B300").NumberFormat = "General"
Next i

 

[holy_eti]

I've found my error, I was selecting a line that had merged cells so it was included in the selection and my selection was enlarged.

 

[holy_eti]

Thank you fluff that was my error. Found it while you were answering me

 

[Fluff]

Glad it's sorted & thanks for the feedback