Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Question
I'm trying to get some help with VB code that auto-fills cell C2 through the
cell in column C where the word "Total" appears in colum A. In this example, it would begin in cell C2 and needs to Auto-Fill down to Row 4 since Cell A4 contains the word "Total" Column A Column B Column C row1 Test1 5 30% row2 Test2 3 row3 Test3 7 row4 Total 15 Here's what I have so far although I need the range to be through the row where the word "Total" appears in column A. Range("C2").Select Application.CutCopyMode = False Selection.AutoFill Destination:=Range("C2:C47") Range("C2:C47").Select Many thanks if you can help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another IF Question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
My first question! | Excel Discussion (Misc queries) | |||
Question Please. | Excel Worksheet Functions |