Cannot select rows in VBA

B

bjdesa

I am trying to find a way to select rows via VBA using the macro below
but when Rows("6:11").Select is executed it selects rows 3 to 18. Does
someone know how I could select the row 6 to 11 via VBA.

Sub Macro1()
'
' Macro1 Macro
'

'
Range("B3:B18").Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Selection.Merge
Rows("6:11").Select
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get a macro to run on all files in a folder and save each one? 0
Delete blank rows 5
Modify Recorded Macro 1
toggeling Macro 3
Help with Macro 3
Condense code 2
Help with VBA to find data delete it change font, add lines then looptill end of file 4
Macro to Copy / paste from 1 workbook to another 6

Top