Thanks Chris. If possible can you please explain how to define dynamic arrays on a sheet? I am trying to define multiple arrays and then use an if type of condition to decide whether to keep or delete the array(s)... good times!
Good stuff, Bill! We won't have time to go deep into dynamic definitions in this series, but we might touch on it. Check out this video for more on position control: ua-cam.com/video/q2ReyVkreUY/v-deo.htmlsi=rHzVJzFJltRHVFH1
Under Sub Variable_Test() we have decleared Name_Store As String, being whole number, right? So why Name_Store = Range(“A1”) containing a text, is returning the same text (not number)?
🔥30 DAY EXCEL ANALYST PLAYLIST
tinyurl.com/4439xtnb
Thanks Chris. If possible can you please explain how to define dynamic arrays on a sheet?
I am trying to define multiple arrays and then use an if type of condition to decide whether to keep or delete the array(s)... good times!
Good stuff, Bill! We won't have time to go deep into dynamic definitions in this series, but we might touch on it.
Check out this video for more on position control:
ua-cam.com/video/q2ReyVkreUY/v-deo.htmlsi=rHzVJzFJltRHVFH1
Under Sub Variable_Test() we have decleared Name_Store As String, being whole number, right? So why Name_Store = Range(“A1”) containing a text, is returning the same text (not number)?
Hi Maz - a string variable holds text, and integer variable holds numbers, specifically whole numbers
@@TigerSpreadsheetSolutions Noted. Thanks!
Hopefully see you tomorrow Maz!
@@TigerSpreadsheetSolutions Exactly tomorrow having internal meeting at the same time… so will watch on reply. Chears