currentregion.select

  1. H

    VBA - Why does my CurrentRegion include blank columns to the right of my data

    I have a workbook that is generated by an online portal. When I try to find the last cell in the data I notice that the column is actually blank yet Excel is acting as if it must contain data. Thus Range("A1").CurrentRegion includes two columns to the right of my data that are completely blank...
  2. D

    Finding and referencing a second set of data

    I have two sets of data. One offset from the other but directly below it. I want to do things to the second set but do not know how to reference it because they both change per iteration of the data. So example: My top set of data is A1:L11. There are 4 blank rows between them. And the...
  3. D

    Copy & Paste 'Database' Then Set Array

    The following code does not allow the 'CurrentRegion' to be selected and 'Set'. I believe it has to do with the pasting does not retain focus of the table that 'Database' creates. Range("Database").Copy Range("A2800").PasteSpecial Paste:=xlValues, _...
  4. C

    Print Preview Macro- Print till end of active text

    Hi I am trying to do a print preview macro that will print to the end of active text. Right now I can only figure out how to print to the certain number that I specify. Ex. On three diff documents one has cells going 50 down, another 150, one 500. I would like for the macro to recognize the...

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