G
Guest
Dear All
I have created exactly the same simple macro on several PCs, but it shows
differently on just one of them and I don't know why. I have a feeling there
must be a setting somewhere either within Excel, VB or even on the individual
PC that's affecting things. I can't seem to find out why and wonder if
anyone has a simple solution please?
The macros should read something like:
Range("H5:H15").Select
Selection.Copy
Range("B5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("C5:F15").Select
Application.CutCopyMode = False
Selection.ClearContents
Range("E1").Select
Selection.ClearContents
but instead it looks like:
ActiveCell.Offset(-14, -1).Range("A1:A11").Select
Selection.Copy
o ActiveCell.Offset(0, -6).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("A111").Select
Application.CutCopyMode = False
Selection.ClearContents
ActiveCell.Offset(-3, -2).Range("A1").Select
Selection.ClearContents
The incorrect macro doesn't even run and I have no idea why Offset and
values are appearing instead of cell references.
Many thanks in anticipation,
Diane Thorpe
I have created exactly the same simple macro on several PCs, but it shows
differently on just one of them and I don't know why. I have a feeling there
must be a setting somewhere either within Excel, VB or even on the individual
PC that's affecting things. I can't seem to find out why and wonder if
anyone has a simple solution please?
The macros should read something like:
Range("H5:H15").Select
Selection.Copy
Range("B5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("C5:F15").Select
Application.CutCopyMode = False
Selection.ClearContents
Range("E1").Select
Selection.ClearContents
but instead it looks like:
ActiveCell.Offset(-14, -1).Range("A1:A11").Select
Selection.Copy
o ActiveCell.Offset(0, -6).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("A111").Select
Application.CutCopyMode = False
Selection.ClearContents
ActiveCell.Offset(-3, -2).Range("A1").Select
Selection.ClearContents
The incorrect macro doesn't even run and I have no idea why Offset and
values are appearing instead of cell references.
Many thanks in anticipation,
Diane Thorpe