Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi experts, this second line of code is making me feel foolish.
The first line does its thing where data is entered and upon enter moves to the right until column 8 then correctly act like a carriage return back to column B and next row down. Once I get past G25 I want to return to B8... what have I got screwed up in the second line? If ActiveCell.Column 7 Then ActiveCell.Offset(1, -6).Select If ActiveCell.Column 7 And ActiveCell.Row 25 Then _ ActiveCell.Offset(-18, -6).Select Thanks, Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C | Excel Programming |