<div>
Hi,<br />
Pls try.. &lt;Not tested.&gt;<br />
&nbsp;<br />
New module-&gt;Global Pawan As Integer<br />
<br />
Hope it helps!
</div>


Hi,
Pls try.. <Not tested.>
 
New module->Global Pawan As Integer

Hope it helps!

<div>
<div class="content wysiwyg-content">
I declared public variables in SHEET1 and referred to them in a procedure I was running in Module1. It didn't work.<br />
I declared public variables in MODULE1 and referred to them in a procedure I was running in Sheet1. It did work.<br />
Is this correct?<br />
I thought a public variable could be declared anywhere and then referred to anywhere.
</div>
</div>


I declared public variables in SHEET1 and referred to them in a procedure I was running in Module1. It didn't work.
I declared public variables in MODULE1 and referred to them in a procedure I was running in Sheet1. It did work.
Is this correct?
I thought a public variable could be declared anywhere and then referred to anywhere.

Excel VBA - Public declaration of variables

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.