| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro on different reports CTRL+F in formula
Cool thank you
On 24 okt, 14:11, Ben McClave wrote: Hello, Once your macro identifies the first cell (as you say that it can), this line will merge the contents of that cell with the cell one column to the right of it: MsgBox ActiveCell.Value & " " & ActiveCell.Offset(0, 1).Value Just change the "MsgBox" part to whatever you need (i.e. a Range value, a variable, etc.) Ben |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a difference between CTRL+D and CTRL+" (quotation marks) | Excel Discussion (Misc queries) | |||
| Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
| use CTRL key inside a macro IE CTRL + ; | Excel Worksheet Functions | |||
| Generate Reports from Excel Using Seagate Crystal Reports PLs... H | Excel Programming | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
