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 wa
Hi
Highlighted means cells filled with specific color or selected cells.
Thanks
On Wed, Jun 19, 2013 at 5:58 PM, rajan verma wrote:
>
> 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 ,
yes i think
On Wed, Jun 19, 2013 at 6:41 AM, VBA VABZ wrote:
> Hi
>
> Highlighted means cells filled with specific color or selected cells.
>
> Thanks
>
>
> On Wed, Jun 19, 2013 at 5:58 PM, rajan verma wrote:
>
>>
>> can anyone suggest a faster way to know which cells are highlighted in a
>> Ra
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) = Hi
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 wrote:
> How about this macro, is this stil