Cell Reference

Question 0

How to go to a certain cell?

Answer 0

Application.GoTo Reference:=Worksheets(“Sheet1”).Range(“A4”), scroll:= True

Question 1

How to refer to a cell in a different workbook?

Answer 1

Application.Workbooks(“Practice Excel03.xlsm”).Worksheets (“Sheet1”).Range(“A4”)

Question 2

How to select visible cells only?

Answer 2

Range(“A1:G1”).SpecialCells(xlCellTypeVisible).Select

Question 3

How to select blank cells?

Answer 3

Range(“A4:K7890”).SpecialCells(xlCellTypeBlanks).Select

Question 4

How to select cells with formulas?

Answer 4

Range(“A4:N4000”).SpecialCells(xlCellTypeFormulas).Select

Question 5

How to select cells with formulas but where the result in an error, e.g., vlookup error #N/A?

Answer 5

Range(“A100:B200”).SpecialsCells(xlCellTypeFormulas, 16).select