excel vba get a range of full rows or columns

'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 find value in range return row excel vba select range of rows using variables vba range entire row vba get column range get row number in range vba vba excel get row number from range vba get columns 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 get rows in a range using vba entire column in excel vba range excel vba range row column reference vba select range with column and row number excel vba reference cell range by row and column number get range of cells vba range entire row vba excel vba range using row and column numbers get row from range vba select row in range vba excel vba code on whole column range cell.row vba excel cell.row vba excel vba array legth values row range of cells vba row column range select entire column in excel vba activate cells entire column vba past column selection vba excel vba macro select a column VBA rows.cells rows.select vba vbscript select row how to select a row in excel vba vba select entire row of active cell select a column in vba how to select a column in vba Excel vba select all columns from row 2 select columns excel vba vba aselect active row new column select full multiple rows formula vba select all rows in excel vba select all row in excel vba row select vba vba select column excel vba select row select full column in excel in vba Columns.Cells vba vba cells all rows excel vba select column how to select a column in excel vba range vba row vba how to call range entire column how to select a whole column in excel vba columns.select vba get row range starts at excel vba vba select column from worksheet excel select column macro select column vba selvba select enrire row active cell and below vba excel row select vba get a range of full rows or columns excel vba get a range of full rows or columns

excel vba get a range of full rows or columns

Welcome Back!

Create a Free Account