dynamic range vba

  1. H

    Object variable not set error

    HI There, I am trying the below code to use a dynamic range for lastfillrange in a combobox. It gives an error of Object variable not set dont know what happened!! Can anyone help? Private Sub ComboBox1_Change() Dim lastrow As Long Dim dyrange As Range lastrow =...
    • HimanshuK
    • Thread
    • dynamic range vba object variable error vba & excel 2013
    • Replies: 19
    • Forum: Excel Questions
  2. G

    Help with data comparison between two sheets

    Before I begin, I should tell you all that I am a complete noob to excel and VBA macro. I am trying to compare two excel sheet data by using EXACT formula. sometimes the data ranges to 50 columns and 10000+ rows, So I am using a VBA macro to define the range and applying the formula. perhaps...
    • greatparthi
    • Thread
    • data analysis dynamic range vba formatting cells from vba formula & macro
    • Replies: 1
    • Forum: Excel Questions
  3. L

    Dynamically find a range within a sheet...help with VBA please!

    I have a macro that opens another worksheet and pulls information via VLOOKUP formulas from a range that I name within that sheet. Recently, for some reason the information has been showing up in different columns on the report and since I can't control how that report is produced, I need to be...

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