get value range strip

  1. S

    Getting value from closed workbook

    Hi there, I have this code which extracts the values I want from the spreadsheet I want, however there is only one problem - hopefully an easy fix. This extracts the data from rows 5 to 28 and columns 26 to 36, but inputs these values into my sheet in the same place. I would like the macro to...
    • sn281
    • Thread
    • closed file closed workbook get value range strip
    • Replies: 5
    • Forum: Excel Questions
  2. C

    Return value from range

    Hello, me again. I'm thinking the index function could help me do this, but I'm not sure how. I want the values from ranges to be copied in column F. So A5:C14 --> would give me in column F 517, 518, 519, 520, 521, 522, 523, 122, 123, 124, 125, 126, 127, 128. And so on for other ranges...

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