Here is the link to a list of functions in PI Datalink that you can use with VBA.
You can put PI DataLink functions (Current values, Compressed data functions etc...) to your cells by VBA. But VBA could not get the returned values by these functions.
Although I think you want to do resize by VBA. So it should work.
Following link shows PI DataLink standard functions.
Just out of curiosity, why you don't want to use automationObject.ResizeRange?