Is it possible to call a function to get the desired number to use in a resize statement? For example, there is a function called getRows that defines the number of current data rows exist. I tried the following but it did not work.
[VBA]
Selection.Resize(getRows).Select
[/VBA]