Transferring Cell Information to VBA memory

R

rjoshi88

New Member
Joined
Sep 4, 2012
Messages
1
Hello everyone,

I am designing a tool to identify whether a cell has inter or intra sheet dependents using VBA. The problem is the extremely slow speed due to interaction with worksheet and use of 'showarrows' and 'hidearrows' function. Can the entire sheet information be copied into VBA memory, so that execution time reduces. ? I am looking forward for any code / supporting link.

Regards
Ruchir Joshi
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You must log in or register to reply here.

Similar threads

E
  • Solved
VBA macro - Match to a single cell, copy multiple hits (with rows) and paste in first available row in a different sheet
2
Replies
11
Views
1K
Alex Blakenburg
A
L
  • Question
Improve VBA transferring cell formatting & values
Replies
3
Views
234
offthelip
O
S
  • Question
VBA to concatenate cells B&C into D, but then clear cell D if B&C are manually cleared - code running slow
Replies
5
Views
386
Zot
Z
G
  • Question
Excel VBA Macro steps through ok but when run it causes duplication
Replies
2
Views
3K
Gassy
G
D
  • Question
Speeding up my code
6 7 8
Replies
78
Views
5K
dpaton05
D

Forum statistics

Threads
1,214,832
Messages
6,121,850
Members
449,051
Latest member
excelquestion515

Share this page

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