![]() ![]() In this type of variable you can store anything, pictures, objects and even entire sheets ![]() To perform calculations on them so use the "Date" The STRING type for dates, you won't be able You can use the "VARIANT" type for all your variables and put anything it them but it is the "anything" that might give you problems later.įile names, path, worksheet names, workbook I want to keep things simple, I essentially In a new workbook enter a value in cell B1, Copy/Paste the following procedure in a module and try it (Go to "Tools/Macro/Macros" select "proTest" and click on "Run"): You are dynamically coding when you enter the name of the file in a cell (A1) and you write.Īt this point you or the user can change the value in cell A1 and open any workbook.Ĭreate variables that you will use as counters. Why should you use variable? The first good reason is to make your code dynamic, to avoid hard coding some values. LONG, SIMPLE, DOUBLE) or almost anything else Is an object that you create and in which youĬan store text (STRING), dates (DATE), numbers (INTEGER, ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |