Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba get a range of full rows

Excel Hero answered on April 2, 2020 Popularity 9/10 Helpfulness 3/10

answer excel vba get a range of full rows

related excel vba get a range of full rows or columns

excel vba get a range of full rows

Comment

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

Popularity 9/10 Helpfulness 3/10 Language vb

Source: academy.excelhero.com

Tags: excel get range rows vba

Link to this answer
Share Copy Link

Contributed on Apr 02 2020

Excel Hero

0 Answers Avg Quality 2/10

Closely Related Answers

excel vba get a range of full rows or columns

Comment

'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

Popularity 9/10 Helpfulness 4/10 Language vb

Source: academy.excelhero.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Apr 02 2020

Excel Hero

0 Answers Avg Quality 2/10

excel vba get a range of full rows

Contents

More Related Answers

excel vba get a range of full rows

Closely Related Answers

excel vba get a range of full rows or columns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.