By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (39 of 1158)

(Clear Filter = *Row*)

FindDataCol("fieldname",row_nbr) udf
Filtering and visible rows
GetNextRow - filtering udf
Rows(i).hidden
Rows collection
Hide columns or rows on a report
Findlastrow - udf - finds the last row in a column
mixing up row and column error
Rows - basic
FindLastCol(1) - find the last column passed a row udf
Rows("1:1").select 'a row
RemoveCanceled - Removes rows with a status of canceled - udf
Rows(i).interior.color = vbYellow ' highlights row i
GetSignature - gets a number based on the number of formulas + number of rows * cols
Rows("1:1").RowHeight = 52.5 ' recorded
Cells.Rows.Count
HighlightTotalRow
fr = Range("first_row").Row
SQL insert rows from data
ActiveSheet.Outline.ShowLevels RowLevels:=1, ColumnLevels:=1 ' recorded
=IfERROR(VLOOKUP(INDIRECT(ADDRESS(ROW(),VLOOKUP($BW2,'Field To Use'!$H:$O,6,0))),'Rating Lookup'!$A:$B,2,0),0)
Rows("9:34").EntireRow.AutoFit
FindDataRow("string",col_nbr)
Selection.Rows.Count
Activecell.Row
iif(num_rows = 20, 1, 0) - immediate if
PivotFields("field_name").Orientation = xlRowField
AR - sc for Activecell.row
Down1 - sub to move activecell down 1 row sc
Type fiilter_Fields row as Long column as Long End Type
Rows, Columns and Cells
Header Row
pptshp.Table.Rows.count
Browse
Cells, Rows, Columns and Ranges
Hidden Rows in Excel
Covert Text date to date - cells(x,y).formula = cells(x,y).value (for all rows)
FindDataRowPartial(sSearch, c) as Long
WrapEntireRowDelete
Top
   
Home | Excel Syntax Checker | About | Videos | Feedback | @alecberg | websites | FAQ | Memes | Thanks | Copyright © 2021 All Rights Reserved. Edit