Autofill Down When Text to Left is Not Blank
 

I am trying to find a way to autofill down, when there is data in the column
to the left. I tried a bunch of things, including the macro recorder, and
cant get a solution. The macro recorder gave me a result such as:
Selection.AutoFill Destination:=Range("C2:C9")

But my range will change all the time and thus I cant use this hard-code
reference.

Please offer a suggestion or two€¦



Regards,
Ryan---


--
RyGuy

Autofill Down When Text to Left is Not Blank
 

Dim LastRow as long
with activesheet
lastrow = .cells(.rows.count,"B").end(xlup).row
.range("C2").autofill destination:=.range("c2:C" & lastrow)
end with

ryguy7272 wrote:

I am trying to find a way to autofill down, when there is data in the column
to the left. I tried a bunch of things, including the macro recorder, and
cant get a solution. The macro recorder gave me a result such as:
Selection.AutoFill Destination:=Range("C2:C9")

But my range will change all the time and thus I cant use this hard-code
reference.

Please offer a suggestion or two€¦

Regards,
Ryan---

--
RyGuy

--

Dave Peterson

Autofill Down When Text to Left is Not Blank
 

Awesome!! Thanks a bunch!!
Ryan---


--
RyGuy


"Dave Peterson" wrote:

Dim LastRow as long
with activesheet
lastrow = .cells(.rows.count,"B").end(xlup).row
.range("C2").autofill destination:=.range("c2:C" & lastrow)
end with

ryguy7272 wrote:

I am trying to find a way to autofill down, when there is data in the column
to the left. I tried a bunch of things, including the macro recorder, and
can€„¢t get a solution. The macro recorder gave me a result such as:
Selection.AutoFill Destination:=Range("C2:C9")

But my range will change all the time and thus I can€„¢t use this hard-code
reference.

Please offer a suggestion or two€¦

Regards,
Ryan---

--
RyGuy

--

Dave Peterson