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

Become an Σxpert at Σ


Standard VBA/Excel (15 of 1182)

(Clear Filter = *find*)

FindDataCol - udf - 🔝
FindDataCol("fieldname",row_nbr) udf
instr( ) - find a string within a string and return the offset
Findlastrow - udf - finds the last row in a column
FindLastCol(1) - find the last column passed a row udf
Ubound(array) - finds the upper bound of an array
lcol = Finddatacol("column header fields",1) ' avoid hardcoding by searching for a column
GettheVersion - opens workbook and finds the version and date by searching the sheet
col variables - stores the number of a column which is retrieved via FindDataCol in case column moves (Hardcoding)
copy modules in and finding all the syntax error
Finding the Macro being Recorded
FindWorkbook(sWB) udf
FindDataRowPartial(sSearch, c) as Long
Find Missing Data