vba

[xxsalahxx]

Hello I have a VBA in a spreadsheet so that all data i enter aligns to the top and left. However when I copy over data from another spreadsheet it seems to override the vba formatting any ideas?

Thank you.


[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Sub Stuff()
Dim wks As Worksheet

For Each wks In Worksheets
wks.Cells.VerticalAlignment = xlTop
wks.Cells.HorizontalAlignment = xlLeft
Next wks
End Sub


[/FONT]

 

[James006]

Hello,

You do not explain if you are copying manually or with a macro ...

You can alwyas have just the Values copied ...

 

[Fluff]

Copy and paste as values.

 

[mumps]

After copying the data, right click the destination cell, click 'Paste Special' and select "Values". This assumes the copy paste is done manually.

 

[xxsalahxx]

Thank you I will try this