Macros on how to copy, paste, edit and remove empty cells

[razor_raef]

Hey all,

I need assistance with the following macros:

As examples, the cell can be A1 but i'll change the code according to where it belongs on my spreadsheet as i'll need them in several places
1) Copy (Ctrl + C)
2) Paste (Ctrl + V)
3) Edit (F2)
4) Edit + Paste (F2 + (Ctrl+V))

This one's a bit different:
5) Where my cells A1 to A5 has text and then A9 to A14 has text. If I copy and paste A1 to A14 and paste into a text document, the text comes up as (for example shown below), I need a macro/script to removing the dead space between two fields so that it goes from this:
__________________________________
Hi
How are you?
This is
A test
Message




This is
How the message
Appears when
Loaded into a
Text document
__________________________________

To this:
__________________________________
Hi
How are you?
This is
A test
Message
This is
How the message
Appears when
Loaded into a
Text document
__________________________________

Thanks all for your help with the above 5 macros.

[GreyGhost]

Hi razor_raef

Problem #5
Several solutions...
Simplest, unless you have a lot of copy pasting on the same day.
I use "Metapad" text editor, a free program -- vastly superior to "Notepad", because you can set it to be always on top.
Unlike Notepad which is always hiding
Metapad has a find and replace for tabs, new-lines, and backslash

Sophisticated solution -- using VBA
select the cells to be copied (for pasting)
run a macro to remove the "dead spaces"
load the result into clipboard ready for pasting

Problems #1 to #4
Need more information, what are you trying to do, more details please.

[HaHoBe]

Hi, razor_raef,

not the best of all thread titles I must admit.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

For me it doesnīt make sense to edit the contents of a cell directly from VBA as that would block the macro until action is ended. You may consider using an Inpiutbox for that:

Please Login or Register  to view this content.

The last code will automaticly paste the value into the cell, you could adapt the cell where to put the value.

Please Login or Register  to view this content.

Ciao,
Holger

[arlu1201]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[razor_raef]

Problem #5
Can't use any other program, must be all done within excel.
I don't know a macro how to remove the empty cells.

Problems #1 to #4
Trying to edit the details with macro buttons because the cell that is merged doesnt allow the clipboard data to be pasted as its not the same size and shape.

I'm going to try upload the spreadsheet so you guys can understand where i'm coming from.

[razor_raef]

Here is the spreadsheet so it can make sense.

I want to ultimately have the following:
1) Edit(F2 button) + Paste macro button for each cell no: Cell I8, Cell I10, Cell K29 & Cell AF29
2) When I click the purple macro copy button, it selects C41:C55 but removes any empty rows between
(for example, if you select the following buttons > Monthly K17 Annual AS17 Lifetime W23 5 Age 60 AC23, you'll see a gap between the two cells at between C45-C47 and C49. I need this gap removed please)

[razor_raef]

Hi all,

Is anyone able to assist with my enquiry?

Thanks
Raef

[HaHoBe]

Hi, Raef,

you didnīt mention in your posts before this problem is about merged cells - Iīm out because of this feature.

Ciao,
Holger

[event21]

Hi razor -

I have modified your VSCopy macro to something like this;

Please Login or Register  to view this content.

event