Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel hard code those #'s without deleting the formula or typing#
Hi,
I received this question from a Excel user: 'I have a worksheet that has cells with data looking at other worksheets. I want to basically hard code those #'s without actually deleting the formula and typing the number in. How do I do that?' Thanks for any information that you may have! |
#2
|
|||
|
|||
CopyEditPasteSpecialValues.
-- HTH RP (remove nothere from the email address if mailing direct) "JudiS" wrote in message ... Hi, I received this question from a Excel user: 'I have a worksheet that has cells with data looking at other worksheets. I want to basically hard code those #'s without actually deleting the formula and typing the number in. How do I do that?' Thanks for any information that you may have! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hard breaks in text to soft breaks in Excel | Excel Discussion (Misc queries) | |||
is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? | Excel Worksheet Functions | |||
Deleting a file from within Excel | Excel Worksheet Functions | |||
In Excel VBA Editor, how do I hide my code from other users? | Excel Discussion (Misc queries) | |||
Excel code conversion | Excel Discussion (Misc queries) |