Empty Clipboard Excel Using Excel Application properties:-
Application.CopyObjectsWithCells = False
Get Position of Last Column Containing Data with Excel VBA:-
Function LastColumn() As Long
Dim ix As Long
ix = ActiveSheet.UsedRange.Column - 1 + ActiveSheet.UsedRange.Columns.Count
LastColumn = ix
End Function
No comments:
Post a Comment