macro help

[lrkfam]

Selection.Replace What:="94:", Replacement:="93:", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="293,", Replacement:="292,", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Cells.Select
Range("FQ179").Activate
Selection.Copy
Sheets("200 low").Select
ActiveSheet.Paste


excel tells me i can't paste all cells from one sheet to another sheet without selecting cell a1 or r1c1

how can i fix this without recording a new macro??

 

[GlennUK]

Tell me why you want to copy and paste ALL cells of a sheet? Surely you should only be copying a specific area. Do you have a specific area to copy?