I have understood that
[VBA]cells(x,y)[/VBA]
and
[VBA]activesheet.cells(x,y)[/VBA]
means the same.
If I want to refer to thisworkbook.activesheet.cells(x,y), is there a shorter way to do it? Is it possible to make cells always refer to thisworkbook.activesheet.cells?
Thanks!
[vba]
With ThisWorkbook.Activesheet
.Cells(x,y)
.etc
End With
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Ok. That seems to work. Thanks!
You can also create a variable for the sheet, and use that throughout your code.
[vba]
Dim ws As Worksheet
Set ws = ThisWorkbook.ActiveSheet
ws.Cells(x, y).etc.
[/vba]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
