Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Cell
Hi All:
I have two questions that are sort of related. 1-I was wondering is anyone knows in excel, how we could know, the last row and column on the spreadhseet that has any data in it? 2- Let's say that you have data on the Range A1:A20, and A1000. At this point the vertical scroll bar is very small. Then if you delete A1000, is there a way to reset the limits on the vertical scroll bar? In the regular VB, you have Scrolbar.min and scrolbar.max. Is there such a thing in VBA for Excel? Thanks for your help. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Programming | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |