Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ ------------------------------------------------ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you hide/un-hide the grid lines | Excel Discussion (Misc queries) | |||
Hide Formula & Allow Copy | Excel Discussion (Misc queries) | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |