Copy on "GO"
 

Hi all,

Have a prob. The following code works ok BUT, i would like 2
additions.

1. After the user clicks GO, i would also like column C values fro
PRICING to copy to column H on INCLUSIONS.

2. When the user form shows, the pricing sheet cannot be hidden....ho
do i have a user form show on opening whilst keeping the shee
hidden??

Cheers in advance!!!!


Private Sub cmdGo_Click()

Application.Goto Reference:="CONFIG"
Set b = Selection
For Each cell In b
mstrX = lblConfig.Caption
mstrCol = cell.Address
If mstrCol < mstrX Then
a = cell.Address
Range(a).EntireColumn.ClearContents
End If
Next


Application.Goto Reference:="number"
Set x = Selection
For Each cell In x
mstrX = cboRows.Text
mstrRow = CStr(cell.Value)
If mstrRow = mstrX Then
Else
a = cell.Address

Range(a).EntireRow.ClearContents
End If
Next
x.Select

End Su

--
gavme
-----------------------------------------------------------------------
gavmer's Profile: http://www.excelforum.com/member.php...nfo&userid=666
View this thread: http://www.excelforum.com/showthread.php?threadid=27440