| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Code Question
try this. You may want row-1. Why are you selecting?
LastRowInB = .Cells(.Rows.Count, "B").End(xlUp).Row .Range("A1:C" & lastrowinb).Select -- Don Guillett SalesAid Software "Stan" wrote in message ... Can anyone tell me what I need to add to the code below to move the range up 1 row? LastRowInB = .Cells(.Rows.Count, "B").End(xlUp).Row .Range("A1:C" & FoundCell.Row).Select Many thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA code question | Excel Discussion (Misc queries) | |||
| Code question for clearing a command checkbox. | Excel Discussion (Misc queries) | |||
| question about excessive code in replacing #N/A when using VLOOKUP | Excel Discussion (Misc queries) | |||
| Easy VB code question | Excel Discussion (Misc queries) | |||
| syntax question - cell references in VB code | New Users to Excel | |||
Hybrid Mode
