wsa

  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. M

    Archive on row from 13 cells

    Hy guys I'm working on my project, but i'm stuck. I search all around the web to get somme idea to finish it. But i can't tell google the good way to find it. I work on a formula, to keep track of my information automatically on another sheet. I got on my sheet1 13 cell to backup on my sheet...
  3. K

    VBA - Name PDF File, Should Be Easy

    Hi all, I have what should be an easy question. I have code that prints a PDF from a spreadsheet. I want to change it so that the file name of the printed PDF references a cell plus some text. For example, in cell Sheet1.cells(1,1).value I have "AC/DC". I want the below code to name the PDF...
  4. S

    Copy rows that meet criteria from 2 sheets into a new sheet

    Hi, I have 2 sheets with data downloaded. I have cross-referenced them and have "yes" and "no" results in Column A in each sheet. I am trying to copy rows with "yes" in column A. I need them to be separate macros because I will have another macro to tidy up the data from "DSS download" table...

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
Back
Top