1

So, the word "Scale" in VBA is reserved and marked in blue (I cannot use it as function or variable name). But I cannot find it mentioned anywhere or any documentation on what it does. It seems to expect input in the following form: Scale (a, b)-(c, d)

What the hell is it?

drgs
  • 375
  • 2
  • 8
  • 1
    It could be this `Scale`: https://learn.microsoft.com/en-us/office/vba/api/access.report.scale – Luuk Oct 17 '20 at 13:57
  • 1
    VBA is weird as to which keyword can be reused and which can't. For example you can't use Len as a method name but Instr is fine. When I run into these type of problems I resort to replacing the last vowel with one with two dots above it. That seems to work ok. e.g. Scalë – freeflow Oct 17 '20 at 17:05
  • 1
    Don’t get me started on Date: a variable type and a function call? – DS_London Oct 17 '20 at 19:17
  • 1
    Just had the same problem, and tried freeflow's idea: scalë (e-umlaut) seems to be fine as a variable name (at least, in the "Immediate" window). VBA is weird as to everything. – captain puget Jan 28 '23 at 23:47

0 Answers0