Your technology certification is waiting. Enroll in Cloud Class ®
An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Dim myWkb As Workbook
Dim myWks As Worksheet
Dim myCell As Range
Dim fname As Variant
Dim fnWkb As Workbook
Application.DisplayAlerts = False
Set myWkb = ActiveWorkbook
fname = OpenMultipleFilesFCN(True)
If IsArray(fname) Then
For i = LBound(fname) To UBound(fname)
Workbooks.Open Filename:=fname(i), UpdateLinks:=2, ReadOnly:=1
Set fnWkb = ActiveWorkbook
For Each myWks In ActiveWorkbook.Sheets
Application.DisplayAlerts = True
Open in new window
Dim mySheet As Worksheet
Dim myRow As Range
For Each mySheet In Application.Worksheets
If mySheet.Name <> "Control Panel" Then
For Each myRow In Range("A1", Range("A" & Rows.Count).End(xlUp))
If myRow.Value = "" Then
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.