yes i think
On Wed, Jun 19, 2013 at 6:41 AM, VBA VABZ v...@vabs.in wrote:
Hi
Highlighted means cells filled with specific color or selected cells.
Thanks
On Wed, Jun 19, 2013 at 5:58 PM, rajan verma rajanverma1...@gmail.comwrote:
can anyone suggest a faster way to know which cells
How about this macro, is this still to slow for your requirement ?
Sub HiLightSelect()
Dim HiSelect As String
On Error Resume Next
For Each i In Selection
If Len(HiSelect) = 0 Then HiSelect = i.Address Else HiSelect =
HiSelect , i.Address
Next
Cells(2, 5) =
I haven't studied above macro provided by De Premor, Nice work!.
You can make it better by collecting all the highlighted cells address in
different worksheet Or you can also use application.Goto Reference.
On Thu, Jun 20, 2013 at 1:07 PM, De Premor d...@premor.net wrote:
How about this macro,
can anyone suggest a faster way to know which cells are highlighted in a
Range ?
suppose i have data of 1 lac cell and i have some cells highlighted , i
want to know address of that cells.
--
Regards
Rajan verma
+91 9158998701
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Hi
Highlighted means cells filled with specific color or selected cells.
Thanks
On Wed, Jun 19, 2013 at 5:58 PM, rajan verma rajanverma1...@gmail.comwrote:
can anyone suggest a faster way to know which cells are highlighted in a
Range ?
suppose i have data of 1 lac cell and i have some