variables

Good day, Excel Guru's! Right to the point: After closing a userform and opening a userform from the same project (addin file) referencing global object variables, I get the RTE 91 "Object variable or With block variable not set". I normally don't use global variables, but this project is...

I need to visualize train paths on a single track railway to suggest optimization of train schedule slots and increased service patterns. The distances the train are traveling are obviously well known and should ideally be displayed on the Y-axis with the fixed points being the (accumulated)...

Hi, I've just started dipping my toe into the world of PowerQuery and M and I can see the potential of what it can do ... however my skills aren't quite there yet ! I have a folder called Weekly Reports that will contain folders full of xlsx files saved by weeks eg : 2018-05-21 2018-05-28...

Hello guys, I have an audacious project in my mind. I want to draw a 16 colour bitmap file in VBA. I want to draw the messages af an LCD display that has 5 lines of 30 characters The file has a size of about 170Kb. I wonder what are the limitations of VBA. Furthermore, is my hardware going to...

Hi- there are 2 sheets: sheet 1 is the Importer and sheet 2 is the Datasheet. I need to bring specific data from the DataSheet to the Importer using variables...not copypaste. I'm using a while loop to place the DataSheet data into the appropriate variables. It loops through the data just...

Can someone please help me fix my formula, Im trying to make it dynamic by using two variables "loanNumber" and "Name". All the other parts are named Cells / ranges. Cells(Rows.Count, 6).End(xlUp).Offset(1, 0).Select ActiveCell.Formula = _...

I'm a novice with excel. I've used it very basically and am trying to expand the near limitless potential. I have a question. We have a spreadsheet with multiple inputs in different columns with assigned values. I'd like to be able to tally each common input and value over the entire sheet. As...

Hello, Can someone tell me if there is something wrong with the way I am defining my variables here? I'm not clear on what it is. Sub Insert_Map() 'We are inserting our variables Dim rngMSRPHeader As Range Dim rngHeaders As Range Dim brand As String Dim mapPolicy As String...

I am having difficulty creating this Macro: Purpose: Using a report that is generated each month, pull information from main sheet and copy onto new sheet, format the sheet and sum relevant numbers. Complete Process: 1) Create 3 new sheet with static names, and copy header information to each...

Hi, I have a simple piece of code that calculates the mass of a gas at a known pressure within a fixed volume (please see below). However, when I run said code, I get a 'Run-time error '6': Overflow' error. When I scroll the curser across the offending line (i.e. m(1) =...) the last bit in...

Hi, I am a Novice in programming, but I have made a calculation tool that solves certain engineering problems. In the main module there is about 10 different functions that uses many of the same variables. To make an easy solution for all functions and not risking typos in new functions and so...

Hello, I'm VBA rookie and i need help from you, VBA Wizards :biggrin: I have this code: Sub roztrideni() Dim PosledniPlnyRadek as Long Dim i As Long 'Rows("1:22").EntireRow.Delete PosledniPlnyRadek = Cells(Rows.Count, "A").End(xlUp).Row For i = 1 To PosledniPlnyRadekIf Cells(i, 1) = "Air Bank...

Hi, I’m looking to create a data table that involves 4 variables. The input variables are: Platinum, Palladium, Rhodium & USD/ZAR. The output is a financial metric EV/EBITDA. I can create two way data tables, but I want to create a data table with all variables included. Is that possible?

hi want to choose rows between 2 variables. get syntax error Rows(r1:d2).Select

Hello All, I am new to the world of using VBA and I am looking to get some help in writing a code that follows a set of conditions and applied it to a data base. I would really appreciate it if someone could assist me learning how to write the task rather than a straight up answer example...

All, I have a large spreadsheet with fishing data on it. Dates, times, tides, water temperature, fish caught, fish targeted etc. It is all in one line by date. Basically it is results (fish) and variables. What would be the easiest way to see which variables are the most important in the...

Hi guys, I'm given a data set on property type as a school assignment and i'm having great difficulty in creating graphs out of numerically-assigned categorical variables. For example, my variable on gender of property buyer has 0 = male, 1 = female 2 = joint purchase. Is there a way for me to...

I have folders G1, G2, G3 The goal is to, for example, select G2 with a dropdown list and have Power Query import the contents of folder G2 My filepath=> C:\Users\MyStuff\Desktop\G1 I've made parameter tables to make variables for entire filepaths for different computers, but am struggling...

Hi, I have a workbook that I've used for years. I know it's not best practice but the variables are not defined. This has never caused an issue, it has always worked fine, but today it is giving me a compile error on every variable unless I dim them. Option Explicit is not set, neither is the...

Hi, I am fairly new to writing code in Excel, but I am using Excel with UserForms to create a config file. In this particular piece I am trying to add multiple sections to the config in the format of: config categoryedit "variable X<variable x="">" </variable> <variable x=""> set comment...