Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to learn visual basic through example. Can somone help me solve
this problem? I have two different Excel workbooks, both located on my desktop. The first is named Book1.xls The second is Book2.xls On Sheet 1 of Book1, under column A (cells 2 through 11) I have the numbers 1 through 10. I would like to write a macro that copies the values in these cells and pastes them into sheet 1 of Book2, in the same cells. Also, I would like for the cells in book 2 to be red, and the font to be bold and white. Please help. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Calling Visual Basic References | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
How do I run a Macro on basic of a value in a specific cell | Excel Worksheet Functions | |||
Date macro | Excel Discussion (Misc queries) | |||
Visual Basic Macro | Excel Discussion (Misc queries) |