beginner

  1. C

    Understanding the Dynamics of VBA

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

    VBA help, creating a macro!!

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

    Beginner Help - UserForm to modify table

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

    Create a multiple nested IF statements

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

    Object variable or With block variable not set (Word through Excel, VBA)

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

    Storing Values by clicking on them

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

    Simple VBA code required to clear cell contents

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

    Limiting Find and Replace Format Function in VBA

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

    VBA tool for searching and sending personalized messages on LinkedIn

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

    Moving 'Total' Rows Below a List of Costs Needed

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

    Maco/ Forumal Help with Pricing - Just starting out

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

    How to construct a loop - find cell A by content, but paste cell B into another workbook.

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

    Beginner Macro Question - unable to get the pivotfields property of the pivottable class

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

    Sorting, Summing, and Gathering Data in Seperate Workbooks

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

    Can you help me understanding how to operate with charts in VBA

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

    VBA not functioning completely - protect sheets and workbooks

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

    Macro to link selected cell to most recently edited cell.

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

    Excel Beginners Guide/Free Training

    Hello, Does anyone know of a good website/free manual that contains Excel training for a Beginner ? Many Thanks!
  19. C

    Help!! find two number recurring numbers in row??

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

    Newbie Userform questions: Userform to variables

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