I finally got it to work from the code below:

Sub Uhrs()
'
' Uhrs Macro
' Macro recorded 7/3/05 by Abay
' Keyboard Shortcut: Ctrl+h
'
ActiveSheet.Previous.Select
Range("B29").Select
Selection.Copy
ActiveSheet.Next.Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=
_
False, Transpose:=False
End Sub

Many thanks again for your help Tom & Alan you pointed me in the right
direction.

Much appreciated!

Abay

Sub Uhrs()
'
' Uhrs Macro
' Macro recorded 7/3/05 by Abay
' Keyboard Shortcut: Ctrl+h
'
ActiveSheet.Previous.Range("B29").Copy
Selection.PasteSpecial Paste:=xlValues, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
End Sub

Is Shorter and should work. You should avoid selecting as much as possible.
It just slows things down.

--
Regards,
Tom Ogilvy


"Abay" wrote in message
...
I finally got it to work from the code below:

Sub Uhrs()
'
' Uhrs Macro
' Macro recorded 7/3/05 by Abay
' Keyboard Shortcut: Ctrl+h
'
ActiveSheet.Previous.Select
Range("B29").Select
Selection.Copy
ActiveSheet.Next.Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:=
_
False, Transpose:=False
End Sub

Many thanks again for your help Tom & Alan you pointed me in the right
direction.

Much appreciated!

Abay

Thanks again Tom .. will try it out .. Abay


"Tom Ogilvy" wrote in message
...
Sub Uhrs()
'
' Uhrs Macro
' Macro recorded 7/3/05 by Abay
' Keyboard Shortcut: Ctrl+h
'
ActiveSheet.Previous.Range("B29").Copy
Selection.PasteSpecial Paste:=xlValues, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
End Sub

Is Shorter and should work. You should avoid selecting as much as
possible.
It just slows things down.

--
Regards,
Tom Ogilvy


"Abay" wrote in message
...
I finally got it to work from the code below:

Sub Uhrs()
'
' Uhrs Macro
' Macro recorded 7/3/05 by Abay
' Keyboard Shortcut: Ctrl+h
'
ActiveSheet.Previous.Select
Range("B29").Select
Selection.Copy
ActiveSheet.Next.Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:=
_
False, Transpose:=False
End Sub

Many thanks again for your help Tom & Alan you pointed me in the right
direction.

Much appreciated!

Abay