excel vba get a range of full rows

To get a contiguous range of entire rows, use this VBA function:

Function WSRows(ws As Worksheet, Row1&, Rows&)
    Set WSRows = ws.Rows(Row1).Resize(Rows)
End Function
  
'-----------------------------------------------------------------
  
MsgBox WSRows(Sheet1, 11, 9).Address		'<--displays: $11:$20
  
'To get the values in the range into a variant array:  
v =  WSRows(Sheet1, 11, 9)
   
'-----------------------------------------------------------------
 
  
'Sister function to a get range of contiguous full columns:  
  
Function WSCols(ws As Worksheet, Col1&, Cols&)
    Set WSCols = ws.Columns(Col1).Resize(, Cols)
End Function

Add Own solution

Are there any code examples left?

Find Add Code snippet

New code examples in category VBA

VBA 2022-03-27 20:55:02 excel vba check if all substrings in list are in string
VBA 2022-03-27 20:40:39 excel vba set cell value to empty
VBA 2022-03-27 17:05:52 vba simple quote
VBA 2022-03-27 14:30:19 textbox find and replace vb
VBA 2022-03-27 09:10:21 nested if else in vb.net
VBA 2022-03-27 09:10:09 excel vba string to bits
VBA 2022-03-25 02:00:15 vba verticalalignment
VBA 2022-03-24 12:20:06 Excel web scraping
VBA 2022-03-24 10:11:00 excel vba BitToLong
VBA 2022-03-21 18:00:05 excel vba save file txt

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

excel vba get range of cells with values loop vba find in range row excel vba find value in range return row excel vba range get column How to fill a value into a range of selected cells vba excel vba select range of rows excel vba select range of rows using variables vba range entire row get row number in range vba excel vba get row and column from range excel vba range get type of data in cell vba excel get used range excel vba get selected range vba all rows of range vba excel get row number from range excel vba get row of range select range using row and column excel vba select a range of cells in excel with values vba excel vba return row from range excel vba get value from range one cell excel vba get value from range vba get row of selected range excel vba get range position get rows in a range using vba get range of table in excel using vba get value from range row using column heading using vba count range row vba exxcel vba select range with column and row number get range of cells vba vba select a range in a row excel vba get range of cells range entire row vba read entire range excel vba excel vba get range from find vba get selected range row get row from range vba vba get range of sheet cell get range vba excel get selected range vba excel vba get cell value from named range excel vba table range multiple columns RANGE ROWS excel Worksheet.Rows as Excel.Range vba number rows 5 methods excel single row range vba range with rows excel vba get a range of full rows

excel vba get a range of full rows

Welcome Back!

Create a Free Account