Macro that shows the contents of a range
Closed
Stevie
-
May 5, 2010 at 11:44 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 6, 2010 at 07:38 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 6, 2010 at 07:38 AM
Related:
- Macro that shows the contents of a range
- Excel if range of cells contains specific text ✓ - Excel Forum
- Selection.autofill destination:=range ✓ - Excel Forum
- Run macro when cell value changes - Guide
- Macro excel download - Download - Spreadsheets
- Spell number in excel without macro - Guide
2 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 5, 2010 at 03:02 PM
May 5, 2010 at 03:02 PM
What do mean exactly by "appear"?
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 6, 2010 at 07:38 AM
May 6, 2010 at 07:38 AM
Not possible. You can either hide a column or show a column, You can partially show a column for some rows only. What you can do is have the column there and let the "Happy Birthday" show up when it is time it to be shown. In other case it just shows ""
some thing like this
=if(a1=today(), "Happy Birthday", "")
some thing like this
=if(a1=today(), "Happy Birthday", "")
May 6, 2010 at 07:33 AM