View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geir[_3_] Geir[_3_] is offline
external usenet poster
 
Posts: 2
Default help with excel macro

I want to copy from E75 to I colum and go to next blank cell.
But tis does not work

Sub copytest(

Range("E75").Selec
Selection.Copy
Range("I" & Rows.Count).End(xlUp).Offset(1, 0

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=
False, Transpose:=Fals
Application.CutCopyMode = Fals
End Sub