Option Compare Text
Sub filteroncomments()
Dim commenttext As String
Dim commentrng As Range
Dim cl As Range
With ActiveSheet
.FilterMode = False
.UsedRange.EntireRow.Hidden = False
On Error Resume Next
Set commentrng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeComments)
O
Dear Experts,
Kindly tell how to filter rows in excel sheet with comment in a particular
column
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1)
Dear All,
Please help on below
*Suman Kumar*
-- Forwarded message --
From: Suman
Date: Thu, Sep 24, 2015 at 1:48 PM
Subject: $$Excel-Macros$$ How to export data from Outlook to excel
To: "excel-macros@googlegroups.com"
Dear All,
I want to learn that how to export d