global

Hello, I have a workbook with 5 sheets. Each sheet (in Cell P1) has the same data validation dropdown list (Source=compname). compname is a named range that includes (Alpha, Bravo, Charlie, Delta, Echo) I have also set a Public variable compset as String. My intention is to get the...

Hi, I need help on VBA code to copy and merge data from 2 pivot tables into a single data set to be display in another sheet. Below is data Sheet 1 in excel. <colgroup><col span="2"><col><col><col></colgroup><tbody> Pivot A Shipto Soldto LV1 LV2 LV3 001 A Local NE Manufacturer...

Hi All, Im trying to get outlook global email address and userId in to my workbook What is the best way to achieve this Please can you help me Many many many thanks

Hello all, I have some code that works in a sub, but I need to use it several times over the course of my spreadsheets timeline. It currently only works on the active sheet, which I also need to change to be the sheet/variable that is called for in the argument when calling the function. This...

Please help before I go mad. I am working on a patient assessment form - there's going to be approximately 80-90 columns of data in each row when it's done. The first part is patient demographics. All I am trying to do is get the next available row. I can't get past the run time error. "Method...

Is there a way for me to declare a variable in a UDF so that it will be available to any UDF that it calls? I tried Public varname as double Global varname as double but they both got error messages. A search turned up several webpages about global variables, but they all seem to indicate...

Hi I have two worksheets, Unique Donors & Donations. I've assigned a unique alphanumeric code to each Donor and need to return that value against their Donations. VLOOKUP returns the first 3 values bu when it comes to a repeated value it stops. Amy help here much appreciated Unique Donors...

I am fairly new at VBA and have been working on this for the past couple of days. I am having trouble using the values submitted through a UserForm. I would like to use the values (rows, columns, x distance and y distance) in another module to set the number of loops needed to populate my data...

I.m running XP and updated my Office a couple of days ago. Ever since I've had to uninstall an Update (KB4462157) each day or it won't load. From Googling it seems I have to turn off Automatic Updates. Can this be done for Office/Excel or must it be Global for the whole computer. I don;'t think...

Hello everybody. I've a situation like this: the same table replicated three times, I need something that allows me to produce the global result (per day and total) in the last table. Consider that the lenght of tables is variable (tomorrow I will have for each table one more row with the date...

Hi I want to define a variable as a global so I can use it on all other sub()s in the module. It is working fine but I noticed one thing. If I created a new sub, lets say sub4(), then this sub4() will not be able to get the value of x unless I go to sub1() and run it again. Why is that? I...

Do I have to dimension a global variable as string, integer etc.? I Have: Global my_age , Continue, Street Should I have: Global my_age as interger, Continue as string, Street as string Would the second way use less memory?

Simple code. I just want it to select a lot of rows and copy them, but I get a "Method Range of Object Global Fail". Sub Copy_h1() ' Range( _...

Hi guys, Working on a niche project today that I don't seem to have found a straight answer for. I have a Bex Analyzer (SAP) query in an Excel file to run a query but I want to trigger a macro at the end of the query refresh/run. I found some code online to figure out when the query is...

Hello, i want to make a global trigger on charts only as following : If a user selected a single point on an X-Y Scatter Plot then Keydown event "Middle Mouse Button" : Run my Macro Here are my problems : 1- I want to make this trigger global for all of my workbook charts even if user...

Good morning. I've the following job: the sub global is always preceded by a pop up of confirmation. Now, I want the pop up only when one cell (example: B2) is empty. Sub global() If Not check Then Exit Sub Call first Call second End sub Function check() As Boolean Dim Answer As...

Hi, I'm trying to set global variables for final row of a region of each sheet I have. I have the following code. However, when I debug.print - nothing prints out. Could someone points out my error or how I go about setting global variables that I could reuse in different procedures within the...

Can I declare a global array that's available to all modules within the workbook, I tried declaring a variant array as Public but it gave me an error

Hello MrExcel, ;) I have a worksheet called GLOBAL I have other worksheets and more are to come. I would like to find a way to copy paste range A1:H500 of all workheets to GLOBAL, all after eachother and then delete empty rows. In the column "I" of GLOBAL I want to know the Worksheets it is...

I have several macros (8 of them) that are linked. At the end of macro 1 I call macro 2. At the end of macro 2, I call macro 3 and so on. The macros apply a series of filters to a worksheet. One of the filters has a lot of names in them. Is it possible to define a global definition of the filter...