Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
109
Views
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
Posted : 03/09/2020 4:24 am
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