PDA

View Full Version : VBA error



Rampage123
10-12-2015, 03:11 AM
Hi all,

I am facing an issue while writing my VBA code

So, I am asking my VBA code to pull out data from a SQL run (refresh existing data every time data is pulled) and then do operations on that (like sort, include more columns using vlookup and so on)

However, pulling data from SQL is taking time and in the meanwhile other operations like sorting are getting completed. Because of this, I am looking at wrong results

Is there a way to ensure the other operations run only post data pulling is over

Thanks

SamT
10-12-2015, 08:25 AM
We're going to have to see the code you're using.

Open VBA, Copy a Procedure.
In the VBAExpress Message Editor, press the # Icon on the menu, then Press Ctrl+V.
Repeat for each Sub and Function.

The # icon inserts CODE Tags with the Cursor between them.