Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get the cell to the right of a merged cell in VBA
Hello,
In VBA I would like to find the cell to the right of a merged cell. (or its column-number) The column of the cell to the right is not just the column of the ActiveCell + 1, but it depends on who many columns are merged! Example: In row 1 Cell A and B are merged. (A1 and B1 are merged) The user can select this merged cell. Its name is A1. (B1 is not existing, as it is merged to A1). In VBA find now the Column of the cell to the right. In the sheet it is C1. (so VBA should give column=3 for C). What is the code for this? ActiveCell.Next gives 2, means "B", this is wrong, this cell is not existing. Thanks for any help Marcel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Select All Visible Merged cell then Spread Cell Data | Excel Programming | |||
Copy data from Single cell to Merged cell | Excel Programming | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Very Basic Problem - Merged Cell Equals Contents of a Single Cell | Excel Worksheet Functions | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions |