Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In a recent response to another query, the solution featured square
brackets. Wishing to understand more, I delved into the VBA Help file to find that it equates to "Evaluate" and suggested that a range could be referred to as [A1] instead of Range("A1"). In a workbook with many instances of Range statements, substituting square brackets will significantly reduce the number of characters in the code (and therefore the file size), but is there a downside to this. Does the method use more resources, or take longer to run? Many thanks -- Ian -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell reference in Square Brackets | Excel Discussion (Misc queries) | |||
converted square brackets in worksheet name excel 2003 | Excel Discussion (Misc queries) | |||
how do I automatically put square brackets around field name... | Excel Discussion (Misc queries) | |||
Bug? Square brackets in file name confuses sheet renames | Excel Discussion (Misc queries) | |||
Custom format a text cell with square brackets: [ ] ? | Excel Discussion (Misc queries) |