variables

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

Hi there, wich of those code will be faster? 10 variables: var1, var2, var3.... Or one variable, a array, with the 10 data: MyArray={"Name","Birthday","Phone",....} Thanks

I recorded a macro to use autofilter to find only two values in column G. Doing so, I manually typed in the two values and used the 'contains' and 'or' parameters to find the values. It worked great. Below is the code: Application.EnableEvents = False With...

Greetings, I am somewhat new to userform objects and how best to structure elements within the userform etc to allow for smooth operations. I have many textboxes, listboxes, a few buttons and whole lot of variables. Let me describe the structure I am trying to build... First, I have a...