Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter results to userform-sheet
Hello, All
I made a userform with a sheet in it and now i want the results of a filtered normal worksheet transfered to the sheet on the userform. How do i realise that ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter results to userform-sheet
wrote in message s.com... Hello, All I made a userform with a sheet in it and now i want the results of a filtered normal worksheet transfered to the sheet on the userform. How do i realise that ? Transfer the contents of visible cell(s) to the user form N10:) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter results to userform-sheet
Private Sub UserForm_Activate()
Dim rng As Range Dim iRow As Integer Dim iCol As Integer Set rng = Sheets("Sheet1").UsedRange For iRow = 1 To rng.Rows.Count For iCol = 1 To rng.Columns.Count Spreadsheet1.Cells(iRow, iCol) = rng.Cells(iRow, iCol) Next iCol If rng.Rows(iRow).Hidden = True Then _ Spreadsheet1.Rows(iRow).EntireRow.Hidden = True Next iRow End Sub Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I link filter results into another sheet? | Excel Worksheet Functions | |||
Wanting to write results to array instead of sheet, results overwriting.... | Excel Programming | |||
How do I show the results of filter? | Excel Discussion (Misc queries) | |||
Query Results to UserForm | Excel Programming |