Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Variables are Curr1 and Curr2
This code is in a module, which is run threw a button on Sheet14, I need to get the variables assigned from Sheet 12 and use them in Sheet14. This works fine as it is, but as the amatuer I am (first proj. in vba) I know your suppose to avoid selecting anything, except I don't know how to do it. So the code is correct, I'm just tyring to use it without the Select command, because I believe it is slowing me down. It takes 16 secs to create a 20x1400 table. Suggestions? ----------------------------------------------------------- Sheet12.Select Cells(8, 41).Select Do If IsEmpty(ActiveCell) = False Then ActiveCell.Offset(1, 0).Select End If Loop Until IsEmpty(ActiveCell) = True Do If IsEmpty(ActiveCell) = True Then ActiveCell.Offset(1, 0).Select End If Loop Until IsEmpty(ActiveCell) = False Dim curr1 'Shear Starting Point Row curr1 = ActiveCell.Row Do If IsEmpty(ActiveCell) = False Then ActiveCell.Offset(1, 0).Select End If Loop Until IsEmpty(ActiveCell) = True Do If IsEmpty(ActiveCell) = True Then ActiveCell.Offset(1, 0).Select End If Loop Until IsEmpty(ActiveCell) = False Dim curr2 'Deflection Starting Point Row curr2 = ActiveCell.Row Sheet14.Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Treeview, avoid selecting node on keydown or up | Excel Programming | |||
Name sheets in VB and Selecting them. | Excel Programming | |||
Selecting sheets | Excel Discussion (Misc queries) | |||
avoid access of hidden sheets | Excel Programming | |||
Changing the value in multiple sheets without selecting those sheets | Excel Programming |