This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using a modified calendar template and am trying to pull certain pieces of information into a new excel spreadsheet. I am running into trouble creating a module that will copy the info into a new spreadsheet because the cells are merged. Is there a way to pull this information from cells that have been merged?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I think the advice provided by Jason should serve your purpose in general. But if it doesn't let me know the specifics to provide you right solution.
In Excel, merged cells are referred to by the leftmost top cell in the range.
For example, if you merge cells A2:C8, you would refer to the merged cells with A2.
So you would use that cell when copying, etc.