| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Cell Formatting to activecell with VBA
Hi,
I wrote the below code to copy formatting of the selected cell to current cell. But its not working. Kindly let me know whats the fault with the code Public Function CopyFormat(myrng As Range) If myrng.Interior.ColorIndex = xlNone Then Exit Function Else ActiveCell.Interior.ColorIndex = myrng.Interior.ColorIndex ActiveCell.Interior.Pattern = myrng.Interior.Pattern End Function Regards, Upendra |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Activecell range copy | Excel Programming | |||
| Copy File from activecell | Excel Discussion (Misc queries) | |||
| Copy content of ActiveCell in a variable | Excel Programming | |||
| Copy format of row above my activecell | Excel Programming | |||
| ActiveCell.Copy Range("R3C27") | New Users to Excel | |||
Threaded Mode
