Don't you just hate different versions of excel? I recorded this simple macro for copying and pasting data from the web type page. All it does it remove the formatting and move to the right cell for pasting the next record into.
Works fine on 2003:
Typically the boss see's said sheet and wants to borrow it, so I send it him over and he's on 98 and it doesn't work. It looks like when you paste in excel 98 it doesn't trigger the event. Is there another way to make this happen in 98?![]()
Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False Cells.Select With Selection .HorizontalAlignment = xlGeneral .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = False End With With Selection.Font .Name = "Arial" .FontStyle = "Regular" .Size = 10 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic End With Cells(Cells(65536, 2).End(xlUp).Row + 2, 1).Select Application.ScreenUpdating = True End Sub
Bookmarks