- In the extension bar, click the AdBlock Plus icon
- Click the large blue toggle for this website
- Click refresh
- In the extension bar, click the AdBlock icon
- Under "Pause on this site" click "Always"
- In the extension bar, click on the Adguard icon
- Click on the large green toggle for this website
- In the extension bar, click on the Ad Remover icon
- Click "Disable on This Website"
- In the extension bar, click on the orange lion icon
- Click the toggle on the top right, shifting from "Up" to "Down"
- In the extension bar, click on the Ghostery icon
- Click the "Anti-Tracking" shield so it says "Off"
- Click the "Ad-Blocking" stop sign so it says "Off"
- Refresh the page
- In the extension bar, click on the uBlock Origin icon
- Click on the big, blue power button
- Refresh the page
- In the extension bar, click on the uBlock icon
- Click on the big, blue power button
- Refresh the page
- In the extension bar, click on the UltraBlock icon
- Check the "Disable UltraBlock" checkbox
- Please disable your Ad Blocker
- Disable any DNS blocking tools such as AdGuardDNS or NextDNS
- Disable any privacy or tracking protection extensions such as Firefox Enhanced Tracking Protection or DuckDuckGo Privacy.
If the prompt is still appearing, please disable any tools or services you are using that block internet ads (e.g. DNS Servers, tracking protection or privacy extensions).
Question
capr
ok so very simple function. I want a range of cells (doubles type) to go into an array. then i manipulate the double array and print the end results.
code should be simple so here we go
first issue is a type mismatch. i don't know why... I think range is giving me a variant type which is fine as long as I will be able to manipulate the values as if they were doubles.
second issue when I go to display the results with the last line. it doesn't work right. I get the data i want but also get a bunch of #N/A values all around the data. no idea what that's about.
any help would be great.
I tried replicating this in another workbook but couldn't... could formatting on the original range cause issues? I would have thought .value will ignore formatting.
SOLVED
sorry I figured it out. was making mistakes with the sizes. Anyone reading this the #N/A means your array isn't that big so the last range function is incorrect in dimensions.
Edited by caprLink to comment
https://www.neowin.net/forum/topic/1179745-excel-macros-copy-cells-into-array/Share on other sites
0 answers to this question
Recommended Posts