So I'm pulling data into worksheet1 from worksheet3 with simple formulas. All of this data is dynamic and will change everytime I run a report (daily).

​

I'm trying to set up mailto/hyperlink to saved email template, but not every row has an email address. I set up a mailto link for the column the addresses are in, but the "blank" cells return a "0" because they still have formulas in them. How can I get excel to ignore the cells without data but that still have formulas?

​

I'm also running into the same issue with VBA to clear the rows below the last data set. Using:

Sub MyClearContentsMacro()

Dim LastColARow As Long

Dim LastSheetRow As Long

Worksheets("7 Day Master").Activate

' Find last row on sheet LastSheetRow = ActiveCell.SpecialCells(xlLastCell).Row

' Find last row in column A LastColARow = Cells(Rows.Count, "C").End(xlUp).Row

' Clear range

If LastSheetRow > LastColARow Then

Range(Cells(LastColARow 1, "A"), Cells(LastSheetRow, "M")).ClearContents

End If

End Sub

​

​

The code itself works - finds the last cell used in column C and clears all rows below it. The issue is, it's counting the formulas as data even though it's blank.

​

I can't get rid of the formulas due to the number of rows in use being dynamic.

​

​

Any thoughts?