Multiple ranges under one command button

[MagnusOlsson]

Hi,

I have a question regarding putting multiple ranges that shows when I click a command button.

I have the ranges C106:D118,D200:D202,C256:I260 that I need to be put in cell D4 when I click a command button.

How do I program this in VBA?

[walruseggman]

I have the ranges C106:D118,D200:D202,C256:I260 that I need to be put in cell D4

What do you mean by this? The values from all of those cells into D4? If so, how do you want it formatted?

Or are you asking for something else.

[MagnusOlsson]

Yes, it's basically text in these ranges that I want to be pasted in D4 when I hit the button.

[walruseggman]

No formatting, as none was specified:

For Each c In Range("C106:D118,D200:D202,C256:I260")
x = x & c.Value
Next
[D4].Value = x