Hello,
I'm have a problem. How can i copy a cell with its properties like cell border to another cell(ActiveCell) in a different sheet.
I need a function for it , like
Function CopyCell( R as Range) as Long
End Function
so i can call it from a cell like =CopyCell(sheet1!A1)
this would copy the cell value with its borders from cell A1 on sheet1 to the ActiveCell(the cell that is calling the function) on another Sheet.
Please help!
Configuration: Windows XP Firefox 3.0.15
.formula copy cell reference in range excel vba clear @if copy cell format Copy multiple cells and paste into one cell column format Copying excel sheet template to another sheet c# Excel 2007 copy multiple cell Excel copy cell if other sheet Excel function to copy value from one cell to another sheet only if the cell has word mike Excel get cell value from previous sheet Excel macro if cell contains copy Excel macro if cell value equal then copy cell Excel.worksheet cell copy clipboard Find the next empty cell and copy text How to automate the copying the content of one cell into another in microsoft excel Hyperlink for a sheet in excel cell vb6 Macro copy cell data to new sheet Ms excel vba find text in a string and copy to another cell Shell script copy contens of two files to single file Two cell data add in one cell in excel sheet