I have excel worksheet contain 3000 rows, and i have to check all cells by use "if then",
if i use excel macro --> no problem.
if i use visual basic --> after 1500 rows, computer stuck and i must Ctrl+Alt+Del,
???
Thanx, Miki
Printable View
I have excel worksheet contain 3000 rows, and i have to check all cells by use "if then",
if i use excel macro --> no problem.
if i use visual basic --> after 1500 rows, computer stuck and i must Ctrl+Alt+Del,
???
Thanx, Miki
An excel macro is VBA (unless you are using an older version of excel), which is VB, just a different environment. If the macro works, examine the macro or simply use the macro code, since it is VBA(VB). Are you trying to make a stand-alone VB program that uses Excel? If you are stuck, let me know and I will help you out.
Thank you,
but,
if worksheet contain 1400 rows, VB6 run ok.
it`s stuck only if worksheet over 1400-1500 rows,
therefor, i`m sure that my program normal and i don`t know why this problem.
Can you post the code so we can help you?
Yep any macro produced in the Microsoft Office Suite is produced in VBA (Visual Basic for Applications). An excellent tool. Really helped me complete some complex Excel spreadsheets (Lookup tables etc).
Any chance you are using Arrays? Post your code so we can look at it. Can't help if we don't see it.