Both of these give the same result. ANy reason to use one over the other? Apparently, ActiveSheet is the default value when one isn't provided.
ActiveSheet.Columns("A:A").ColumnWidth = 30 Columns("A:A").ColumnWidth = 30
Both of these give the same result. ANy reason to use one over the other? Apparently, ActiveSheet is the default value when one isn't provided.
ActiveSheet.Columns("A:A").ColumnWidth = 30 Columns("A:A").ColumnWidth = 30
It depends where the code is. If it is in a worksheet module, then the latter will refer to the sheet containing the code, whether it's the active one or not. Anywhere else, the two are equivalent. In my opinion, it's better to be specific.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks