One problem I've never quite straightened out is naming variables.
The only way I seem to be able to reliably create variables is by using the FOR() command whose first entry is a counter variable.
When I'm jumping between documents it is sometimes handy to carry a value loaded in a variable. My technique since I don't know how to call them out is to load the variable into a cell of the macro itself and then call that cell for the variable, but it frustrates me that I can't figure the variable thing out and there were a few really cogent lurkers out here over the last couple days who, when stretched, remembered their XLM so I though I'd ask while I was thinking about it. Elsewise, I'll finish this project and not figure this out yet again and I've been trying to find out for 4 or 5 years.
so if you can enlighten thanks,
PS -
I got Crossover for the Mac actually unzipped the macrofun.exe file and then opened it with Microsoft Word and the word variable only shows up one time in the whole thing as a tag to an article it seems. That is the same with my Excel 2.2 book. I cannot figure out how they can't have devoted a little more attention to the concept, but mayb the metaphor of a macro cell address as a variable address was what everybody used.
The only way I seem to be able to reliably create variables is by using the FOR() command whose first entry is a counter variable.
When I'm jumping between documents it is sometimes handy to carry a value loaded in a variable. My technique since I don't know how to call them out is to load the variable into a cell of the macro itself and then call that cell for the variable, but it frustrates me that I can't figure the variable thing out and there were a few really cogent lurkers out here over the last couple days who, when stretched, remembered their XLM so I though I'd ask while I was thinking about it. Elsewise, I'll finish this project and not figure this out yet again and I've been trying to find out for 4 or 5 years.
so if you can enlighten thanks,
PS -
I got Crossover for the Mac actually unzipped the macrofun.exe file and then opened it with Microsoft Word and the word variable only shows up one time in the whole thing as a tag to an article it seems. That is the same with my Excel 2.2 book. I cannot figure out how they can't have devoted a little more attention to the concept, but mayb the metaphor of a macro cell address as a variable address was what everybody used.
