Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range().Select not working
Please help! I have a command button on a worksheet, that when the user highlights a cell with an employee name in it and presses the button, it takes them to a different worksheet, inputs the highlighted cell's value into cell B1 (which is linked to a combobox) and then calls a macro. The code for the command button is as follows: Private Sub CommandButton1_Click() 'Employee Detail Button ' Lookup selected employee and load data on Employee Summary tab Dim EmpLookup As Variant EmpLookup = ActiveCell.Value Sheets("Employee Summary").Select On Error Resume Next Range("B1").Select ActiveCell.Value = EmpLookup Call Load_Emp_Summary End Sub My problem is that when the sub is stepped through, the Range("B1").Select line does not work (everything else does), and so the name gets inputted into whatever cell happens to be highlighted in the worksheet. Can anyone tell me why that line won't work? Is there another way to force selection of cell B1? I am using Excel 2003... Thanks, Kez -- clmarquez ------------------------------------------------------------------------ clmarquez's Profile: http://www.excelforum.com/member.php...o&userid=29386 View this thread: http://www.excelforum.com/showthread...hreadid=494049 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
range("a1").select not working | Excel Discussion (Misc queries) | |||
range select not working with small sets | Excel Programming | |||
Select Range - using Offset ( 40 ,0 ) - not working | Excel Programming | |||
Select Sheet then Select Range | Excel Programming | |||
Range().Select Not Working | Excel Programming |