Copying Range

[joehjas]

Hi, first time poster here.

I'll get right to my problem.
I'm currently trying to make a button, which when pressed inserts data from one part of the worksheet to another part.
The thing is, I only want it to copy the data not the actual formulas present in the cell.
Currently I am using Range(cell) = Range (orginal cell) for each cell, but it have to be an easier way?

[Steffen Thomsen]

Hi,

Try this

Please Login or Register  to view this content.

[joehjas]

Nice, thanks

Any way to remove the outline of the copied area afterwards? You know the dashed lined around A6 in this case

[Steffen Thomsen]

Please Login or Register  to view this content.

[kieranbop]

after cutting it you might also want to add

Please Login or Register  to view this content.

as often I hate looking at a Highlighted box in the middle of an excel sheet where you know something's just been copy and pasted.

[Steffen Thomsen]

Nope, bad advise.

Do not use select statements in vba code!

[joehjas]

Nope, bad advise.

Do not use select statements in vba code!

Why is this a bad advice?

[hojkoff]

There is no need to go through the paste board to do this operation.

Try this:

Please Login or Register  to view this content.

And agreed, what exactly is wrong with .select?

Can you also clarify what you mean by, dotted outline? Do you mean the outline that appears when you press copy? Or do you mean a border that you have around that cell?

[Steffen Thomsen]

Because selecting and activating sheets in vba is slow and a bad habbit

[hojkoff]

What's the best way to change the sheet that is in view? Or to place the input box on a specific cell?

[Steffen Thomsen]

To change something on a sheet, reference it.

Instead of activating and selecting cells like this

Please Login or Register  to view this content.

Then reference without selecting

Please Login or Register  to view this content.

Allways better, faster end easier to read if sheets, cell and so on are not being selected/activated

Steffen Thomsen

[joehjas]

Can you also clarify what you mean by, dotted outline? Do you mean the outline that appears when you press copy? Or do you mean a border that you have around that cell?

Yes, this(see underline).

Steffen fixed it with Application.CutCopyMode