range as var

  1. Z

    VBA: Set HeaderRowRange as a Range Variable

    Hello, I'm trying to set a dynamic variable using a Tables HeaderRowRange. I figured if I can select the range using ActiveSheet.ListObjects(1).HeaderRowRange.Select that I could then store that selected range into a Range variable. Sub SetRange()...
  2. M

    VBA setting range using variables

    Hi All I've run into a problem, clearly I am doing something wrong! I am trying to set a range using both columns and rows as variants. Please see code below. Any help, much appreciated. Best, Mizogy Dim FirstRow As Variant Dim LastRow As Variant Dim ColumnStart As Variant Dim ColumnEnd As...

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