Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to save entire Cell in a variable and put it back later?
Hello -
I wrote a little deleteCell() function that deletes a cell and shifts the cells below up. I had to do that because most of the sheet is locked and I don't want the user to fool with it. So I wanted to give the option of a undelete as well. I store the .Value and ..Interior.ColorIndex in a string and integer respectively. I was wondering if I could store the entire cell in an object or something like that? I want to keep all the formatting including character font etc. ... I tried ... ' Global dim gCell as object Set gCell = lSheet.Cell(1,1) This works ... just not when I try to assign it back later ... lSheet.Cell(1,1) = gCell I cannot just copy it to the clipboard because the user might put other stuff there in-between the calls. How can I make this work to easily store and restore the format of the cell. Would the CellFormat type work instead of the Object type? Thanks, Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To give back ground colour for entire row on certain condition | Excel Discussion (Misc queries) | |||
How to save same excel workbook in different folders as a back up | Excel Discussion (Misc queries) | |||
Issue with save xls file to html and than back to xls | Excel Discussion (Misc queries) | |||
SAVE is not available in Excel under FILE. How do I get it back? | Excel Discussion (Misc queries) | |||
Sending variable data to a web site to be computed then brought back to Excel | Excel Programming |