Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Excel users and Experts,
Excel 2002 This bit of code is giving me app/obj error. If the activecell is G18 (which will change often) I want to return the values from: Column D and the active row Active column and row 12 Sub ReturnName_Date() Dim j As Integer Dim i As Integer 'Activecell is G18 'Want values from D18 and G12 j = ActiveCell.Column ' G i = ActiveCell.Row '18 Range("F1").Value = Range("D:" & i).Value & Range(j & ":12").Value End Sub Thanks, Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error 1004, Application-definded or object-defined error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Application-Defined or Object-Defined Error on simple code | Excel Programming | |||
Application-Defined or Object-Defined Error on simple code | Excel Programming | |||
Application / Object Error 1004 | Excel Programming |