Activating cell fails

**Alexander_Golinsky** · 08-14-2012, 03:16 AM

Hi all!!

I have a several macros that or open or close files (up to 70 files at once). At the end i'd like to see the particular cell -A1 of the main file main worksheet. For this i use

Please Login or Register  to view this content.

But it doesn't help. Vba just ignores this statement. Thanks in advance!

**LadiskoCZ** · 08-14-2012, 03:22 AM

Hi,
try this

Please Login or Register  to view this content.

**nilem** · 08-14-2012, 03:23 AM

maybe

Please Login or Register  to view this content.

**Alexander_Golinsky** · 08-14-2012, 03:42 AM

Nilem, thanks for replying! From VBA F1: "To make a single cell the active cell, use the Activate method." And I've tried it before..

---------- Post added at 02:42 AM ---------- Previous post was at 02:37 AM ----------

LadiskoCZ, THANKS! it works!