worked it out for myself, posting answer in case it is helpful to
others
dim aRow
aRow = ActiveWindow.ScrollRow
ActiveWindow.ScrollRow=50
On 29 Sep, 00:08, stuartR wrote:
> With the top row frozen and the sheet scrolled down so that the first
> visible row below row 1 is row 32.
>
&g
With the top row frozen and the sheet scrolled down so that the first
visible row below row 1 is row 32.
How would I prove row 32 is the first visible row through VBA
If i then wanted to make row 50 the first visible row, how could it be
done through VBA
--
-
Currently running Excel 97 on XP, everything works just fine.
I am about to buy a new computer that will arrive loaded with Windows
7
I understand the Office97 / Excel 97 will not work on Windows 7, is
this correct?
I have no wish or desire to buy office 2007, complete waste of money
since excel
Hi,
Advise needed on structuring a workbook and its modules.
I have a workbook that has become rather large over the years. The
total size of the workbook is about 6meg, of which 4.2 meg is the
modules and 1.8meg is the worksheets. For email purposes I would like
to keep the module separate from