wba

  1. G

    User Forms and Global Variable

    The below is my code. When ufmAccount is shown, it no longer recognizes wsA. It returns a runtime error 91. Why is this? I thought a public variable can be used throughout. Thank you in advance. Public wsA As Worksheet, wbA As WorkbookSub NewExpense() Dim sExpDesc As String, sReplace As...
  2. N

    Filling in multiple sheets in another workbook while filling in a sheet in a master workbook

    Hallo, What can you suggest for the following? Description: There are 2 workbooks, workbook A (wbA) and Workbook B(wbB). wbA - is a summary file, which has several columns filled in on daily basis. Each row in column A contains sheet names of wbB. https://ibb.co/kBcghU wbB - is a...
  3. N

    WB to WB Copy-Paste Error

    Hallo. This is a simple copy paste task but VBA makes me crazy with errors. Where is my mistake? The task is to copy a range of cells from WBb to WBa. Both of WBs are open. Sub GasRate()Dim WBa As Workbook Dim WBb As Workbook Dim lastRow As Integer Set WBa = Workbooks("GL Rates...
  4. R

    VBA - assign WB to new variable, save and close but keep previous variable open.

    This is/was hard to put into words for a title and as such a search. I have never needed to do this, but now I do so need some guidance. I have a workbook that I am assigning to a variable. What I want to do is use that workbook like a template. I have to make 48 similar workbooks, but...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top