Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
coding for external download
Dim Employee As String Dim EmployeeImport As String Application.ScreenUpdating = False Application.Worksheets("ACAPSCBS").Activate Range("ACAPSCBSNoteList").EntireRow.Delete Range("a1").EntireRow.Delete Application.Range("ACAPSCBS!A1").Name = "NewPasteLocation2" ' For Each cell In Range("historical!a41:Historical!a41") ' Employee = Range("HISTORICAL!A4").Text For Each Cell In Range("Employee!F2:Employee!F19") If Cell.Offset(0, 1) = Range("historical!b4").Value Then Employee = Cell.Value Application.Worksheets("ACAPSCBS").Activate Range("a65536").Select Selection.End(xlUp).Activate ActiveCell.Offset(1, 0).Activate Application.ActiveCell.Name = "NewPasteLocation2" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
items chosen to download are NEVER all there after download comple | New Users to Excel | |||
download from external source | Excel Discussion (Misc queries) | |||
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? | Excel Programming |