I am just getting started in VBA & have watched about 20 videos. . . my issue is that I can't find anything that explains the basic concept of understanding coding in VBA. Everything I have seen explains single aspects, but doesn't encompass (for example) how the to string together commands & to...
Hi I want to create a button on an Excel spreadsheet which will go into a folder, open up the most recent excel file. Add together several cells in that file (B12,B13,B14,I8,I13) then display the answer in the spreadsheet which contains the button (in cell J3).
I've already started the code...
I'm trying to learn some VBA to set up a draft board for fantasy football and was hoping for some help. I currently have a table with the Player Name (column G), as well as two sets of check boxes (columns C & D) indicating whether they've been drafted by an opposing team or myself. The check...
Hi there,
I am new to this forum (1st Post) and also new to excel.
I am currently doing my bookkeeping course and i am stuck on a question and need some help.
The exercise asks me to create a multiple nested IF statements (with the average function nested in the IF statement) in column F to...
Hey,
I'm discovering VBA during my internship and there is no one at work who can really help me so I came here to ask for some explanations.
In my procedure (Sub WordTreatment () ),
the code stops running at the bold line and I don't really understand why. (Error : Object variable or With...
<tbody>
CrankAngle
1100 RPM
1200 RPM
1300 RPM
360
0.7 Pascal
0.5 Pa
0.6 Pa
359
0.6 Pa
0.6 Pa
0.8 Pa
358
0.5 Pa
0.4 Pa
0.9 Pa
357
0.4 Pa
0.3 Pa
0.3 Pa
</tbody>
I have a spreadsheet of pressures with rpm as columns and Crank Angles as Rows. My task is to write a macro to extract a...
I have a very large spreadsheet that requires processing soon.
The records in Column AD are drop down dependent on the answers to the same row in column AE.
I am only a VBA beginner and I have tried, but not yet succeeded, to write/find some VBA that will clear the related row entry in column...
Hi there!
I'm pretty new to VBA programming, but I built the Find and Replace function below that searches for the value in each row of the first column of sheet 5 and if it finds a match it replaces the format in sheet 5 to the cell in sheet 1.
It works currently, but I'd like to change it...
I spend hours messaging people on LinkedIn every day. I have compiled a sheet in excel of all the people I message and their respective schools.
I've gotten my messaging process down to an exact science... Basically, I set a bunch of filters in a LinkedIn search, copy and paste a name from my...
Ok, so at the moment I am trying my best to manage my money. As a student, I have to be very tight with money (which I haven't been so far).
Anyway, today I decided I'd best start making a list of what money is coming in and out until (as I'm a student in England, I get student loans but I...
I'm quite a beginner with excel and was wondering if anyone can help me with either a formula or a macro.
I have a testing document where electricians record if fittings pass or fail. If a fitting fails I want to be able to provide a quote to the customer.
So I have 3 cells where I choose...
Hey guys,
I've been lurking in the existing threads, but not sure how to approach it yet. Should be straightforward, but I'm not very competent with syntax. Consider this table.
<tbody>
Patient id - 336
Diagnosed
Diabetes Type 1
Age
32
Insurance number
GP notes text
Patient id - 118...
Hi everyone, I am very new to using macros with excel.
I'll give you a quick summary of what I'm trying to do:
Output a query from Access to Excel.
Create pivot table from data
Format pivot table
I've recorded the macro and played it back correctly (without error) on the original file. When...
HI everyone,
I am having some trouble with a work assignment and fairly new to excel and hoping someone will be able to assist. I will try my best to be as descriptive as possible.
i extracted some data from an outside source and it looked something like this:
WORKBOOK 1
<tbody>
ID and Name...
Hi Forum!
This is the first time I try to work with charts in Excel.
I need to create charts using macros, in Excel 2010, but I can't figure it out what's the problem. First I tried it the easier way, at least I thought that would be it, using record macro. After I have finished, what I've...
Being new to the VBA band wagon, i'm having some issues troubleshooting the code below. It is supposed to be able to choose multiple excel files in a folder and protect all of the worksheets within them as well as each workbook. The protect of the workbook does not have a password, it is simply...
Hey folks. Looking to make a very basic macro, but my VBA skills are below basic!
Essentially, I want a macro that when used will set the currently selected cell to reference to the cell I most recently edited. So for example, after I complete the sum in C9, I want to go to cell A1, run my...
Hi everyone, new to posting on this forum so thank you for your patience. </SPAN>
</SPAN>
I have a spreadsheet which has data in 7 columns and around 100 rows. I want to be able to find what two numbers appear most frequent together on each of the rows. They don’t have to appear side by side...
I appologize if this has been discussed elsewhere, I did a quick search on here and didn't come back with anything that suits my needs. Moreover, I've also searched google as well.
I just started using Userforms today. I've used Visual Basic before so I understand some about the theory about...
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.