ExcelBanter - Macro to cut/paste from different workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Macro to cut/paste from different workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/123695-macro-cut-paste-different-workbooks.html)

Hawkdriver

Macro to cut/paste from different workbooks

I am trying to cut and paste from/to merged cells and select the next cell
with ActiveCell.Next.Activate with no luck. Will this not work with merged
cells? and if not how can I accomplish it?

Jason

Hawkdriver

Macro to cut/paste from different workbooks

Disregard! I got it using the offset.

"Hawkdriver" wrote:

I am trying to cut and paste from/to merged cells and select the next cell
with ActiveCell.Next.Activate with no luck. Will this not work with merged
cells? and if not how can I accomplish it?

Jason

All times are GMT +1. The time now is 03:57 PM.