Selecting Last Row and Rows with specific words

[ExcelNoob222]

Hi,

My first issue is I am trying to select the last row of my data from column A to K. The below code selects the right cell in column A but I cant seem to figure out how to get the selection to column K.

LastRowFormat = Range("A" & Rows.Count).End(xlUp).Row
Range("A" & LastRowFormat).Select

I have tried:

LastRowFormat = Range("A" & Rows.Count).End(xlUp).Row
Range("A:K" & LastRowFormat).Select

and

LastRowFormat = Range("A" & Rows.Count).End(xlUp).Row
Range("A" & LastRowFormat & "K").Select

Any ideas?

My second issue. I have another tab with subtotal rows. I want to be able to select all of the subtotal rows and highlight them and put thick border around. Any easy way to do this?

Thanks!

 

[mumps]

Try:

Sub x()
    LastRowFormat = Range("A" & Rows.Count).End(xlUp).Row
    Range("A" & LastRowFormat).Resize(, 11).Select
End Sub

Fore the subtotal rows issue, it would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[ExcelNoob222]

Try:

Sub x()
    LastRowFormat = Range("A" & Rows.Count).End(xlUp).Row
    Range("A" & LastRowFormat).Resize(, 11).Select
End Sub

Fore the subtotal rows issue, it would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

This is great! That solved my first issue. For my second, I was able to get it! Thanks again.

 

[mumps]

You are very welcome.