Hide & Copy
 

1- How can i hide the original sheet background (Rows&Cells) i want it
look white sheet.
ToolsOptions
select the "View" page and uncheck the Gridlines check box.
in VBA ActiveWindow.DisplayGridlines = False

2-How can i copy the same formula for cell to another?
select the formula from the formula bar
Copy and hit Enter select the cell you want the formula in and paste.
in VBA select the cell where the formula is
and if the formula should go in to B2 then
Range("B2").Formula = ActiveCell.Formula

HTH
Cecil

"abds2000" wrote in message
...
Hey all,

I have two questions,

1- How can i hide the original sheet background (Rows&Cells) i want it
look white sheet.

2-How can i copy the same formula for cell to another?

Thanks in Advance.



------------------------------------------------
Message posted from http://www.ExcelTip.com/

-- View and post Excel related usenet messages directly from
http://www.ExcelTip.com/forum
-- Hundreds of free MS Excel tips, tricks and solutions at
http://www.ExcelTip.com/
------------------------------------------------