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

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.

Hi, razor_raef,

not the best of all thread titles I must admit.

Sub Number1()
Range("A1").Copy
End Sub

Sub Number2()
Range("F1").Select
ActiveSheet.Paste
End Sub

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:

Sub Number3()
With Range("A1")
  .Value = InputBox("Edit the value for " & .Address(0, 0), "Edit Cell value", .Value)
End With
End Sub

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

Sub Number5_Constants()
On Error Resume Next
Range("A1:A14").SpecialCells(xlCellTypeConstants, 23).Copy Range("E1")
End Sub

Sub Number5_Formulas()
On Error Resume Next
Range("A1:A14").SpecialCells(xlCellTypeFormulas, 23).Copy Range("E1")
End Sub

Ciao,
Holger

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.

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