Forum

how to use two shee...
 
Notifications
Clear all

how to use two sheets of excel at a time by using VBA Code

2 Posts
2 Users
0 Reactions
109 Views
(@salim-gul)
Posts: 33
Trusted Member
Topic starter
 

Hi Everyone 

 

any one can tell me the vba coding of excel, for using or working two sheets at a time, here i have attached a image for understanding what i want VY2TA.jpg

 
Posted : 03/09/2020 4:24 am
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

Hi Salim,

Your screenshot shows 2 Excel workbooks side by side but that doesn't really relate to using VBA.

To refer to 2 worksheets or workbooks is straight forward but without an idea of what you want to do, any example I give will be of little value.

You can write a value to A1 in worksheet 1:

Sheets(1).Range("A1").Value = "Excel"

and into Sheet 2

Sheets(2).Range("A1").Value = "Excel"

Please give a clear example of exactly what it is you are trying to do and supply your workbook(s) and code and I'll see what help I can provide.

Regards

Phil

 
Posted : 03/09/2020 6:09 pm
Share: