View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
leerem leerem is offline
external usenet poster
 
Posts: 88
Default Amending another formula

Sorry to be a pain once again.

I need to copy over rows BE to BY but only by the number of rows in column AX
I've tried the code as below but the code comes to a halt on line 3

what have i done wrong , its probabley simple but I cant see it...

Lastrow = Cells(Rows.Count, "ax").End(xlUp).Row
Range("BE11:BY11").Copy
Range("Be12:Be" & Lastrow).PasteSpecial Paste:=xlPasteAll,
operation:=xlNone, _
skipblanks:=False, Transpose:=False