|
DEclaring variables
Hi
I have declares as a Public variable strNumber doing: Public strNumber as variant when the code opens runs other module in a different worksheet the variable is empty how to solve it? thanks Pedro ps. Chip thanks for all your help |
DEclaring variables
Pedro,
Are you declaring the variable in a standard code module, rather than a sheet's code module or a form or ThisWorkbook? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pedro" wrote in message ... Hi I have declares as a Public variable strNumber doing: Public strNumber as variant when the code opens runs other module in a different worksheet the variable is empty how to solve it? thanks Pedro ps. Chip thanks for all your help |
DEclaring variables
I am declaring it in the standard module
"Chip Pearson" wrote in message ... Pedro, Are you declaring the variable in a standard code module, rather than a sheet's code module or a form or ThisWorkbook? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pedro" wrote in message ... Hi I have declares as a Public variable strNumber doing: Public strNumber as variant when the code opens runs other module in a different worksheet the variable is empty how to solve it? thanks Pedro ps. Chip thanks for all your help |
| All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com