Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
Shortcut to switch from "fill down" to "copy" with mouse drag | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming |