InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,558.71
(
0.90%
)
US TECH 100
19,822.40
(
0.92%
)
Dow Jones
39,265.36
(
-0.11%
)
Brent Oil
87.00
(
-0.38%
)
Bitcoin
56,805.58
(
-0.31%
)
Post# of 47146
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

The Grabber

Send PM Follow Ignore
Followers 21
Posts 3695
Boards Moderated 1
Alias Born 01/30/2002

The Grabber

Member Level

Re: Conrad post# 33210

Wednesday, 12/01/2010 6:38:36 PM

Wednesday, December 01, 2010 6:38:36 PM

Post# of 47146
Re: Freezing Cells

Conrad. My 'proposed' solution notwithstanding, the date approach works as well. All that is really needed is some type of value to reference in your conditional.

I did a search for conditional recalculating at Microsoft and got 'bumpkis' (typically).

There is a bulletin board like site I used years ago that is populated with Excel Geeks way beyond you and I. It's free. You may need to register to ask a question, but the price it right.

http://www.mrexcel.com/forum/index.php?s=f8c3026c9c333d1c45a587a5dcce53b3

Best Regards, Steve (The Grabber)

Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up