vbasic

  1. P

    JSON file within VB

    Hello. I am loading up a JSON file with particular data and dumping it out to Excel. The process works, but when I try and grab the next set of data, I get an error. I am assuming the JSON file needs to be cleared/emptied so that the next 50 rows of data can be loaded. Does anybody have a...
  2. N

    Formula/Vbasic Search

    Need some help. I am working with a large flat file listing reporting relationships. What I would like to find is what I refer to below as the Final Supervisor. Each employee eventually reports up to a Final Supervisor. Do you know of a formula/ Vbasic that I can run so that for each employee I...
  3. R

    VB: default cell formula

    Is there a way to assign column cells a formula that references other cells in VB. I have gotten around this by running a macro that copies the previous cell formula from above and pasting it on line below. that method has flaws that I can no longer use. The idea is to make cell C2 = B2*A2...
  4. X

    Simple Macro Code

    Hi All Can someone possibly help me with some code, I want to write a macro that will take the user to a particular cell and move the screen accordingly, when they click the macro button. Sounds simple enough, i hope it is but i have no idea. ManyThanks in Advance Gary
  5. X

    VB

    Good Morning CAn someone tell me if its possible to write a macro that will ammend the code in other Macros? I have the code below, but i want the users to be able to amend the range (highlighted in RED) ideally by entering a number on the sheet and hitting a button to activate a macro that...
  6. X

    VisualBasic

    Hi I am trying to create a macro that will change the scource data of my chart to resize the data range, however i want it to automatically resize according to either howmany columns of data there are present or have a popup that will request the number of columns to include as series. any...

Watch MrExcel Video

This Week's Hot Topics

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
Top