Select certain visible/non-hidden areas

  • Thread starter Thread starter 0-0 Wai Wai ^-^
  • Start date Start date
0

0-0 Wai Wai ^-^

Select certain visible/non-hidden areas

Hi.
How can I select certain visible/non-hidden areas only?
Eg 1:
- I try to hide column C, F, H, K, L, P, X, Y
- Then I highlight column E-Z (visible columns only, ie excluding the hidden
ones)
- Perform some actions
How to do?
Any workaround is appreciated.


Eg 2:
- Similar to "eg 1"
- the difference is I type a formula first. At the time I am typing the formula,
eg "=countif("
At the point I typed "(", I go and highlight column E-Z (visible columns only,
ie excluding the hidden ones)
- Then I finish the rest of the formula
How to do?
Any workaround is appreciated.
 
Anne Troy said:
Select those columns, then hit Edit-->Go To-->Special, Visible cells only.
Click to expand...

Thanks for your help.
This method is useful although it cannot be used in my second example.

I wonder if there are any workaround to do.
Eg: Instead of using "hide", I may use other properties to mark these undesired
areas.
So when I select the whole areas, it will somewhat remove the undesired areas
for me.
 
You could try working with named ranges (rng1, rng2) to simplify your
formula creation.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top