Prev: Date Help
Next: frustrated excel newbie
From: msnyc07 on 27 May 2010 17:36
I am trying to automate putting a sheet value into Row I. My manual method
is to paste the formula in I2 (since values begin on Row 2), then go to A2,
Ctrl Down until I hit the last record (there are cases where there are blanks
so sometimes I need to do this a few times) and when I reach it tab back over
to the same row in I and Ctrl-Shift Arrow Up and then Fill Down.

Somehow this doesn't work very well when recorded as a macro, any
suggestions appreciated.

In my ideal world in fact once this script worked for a page I'd have a VBA
script that would step through each page and apply the function and voila!
From: Don Guillett on 27 May 2010 19:19
mc="c"
lr=cells(rows.count,mc).end(xlup).row

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"msnyc07" <msnyc07(a)discussions.microsoft.com> wrote in message
news:2B67781D-6CEA-4352-BD7B-818F85381FC8(a)microsoft.com...
>I am trying to automate putting a sheet value into Row I. My manual method
> is to paste the formula in I2 (since values begin on Row 2), then go to
> A2,
> Ctrl Down until I hit the last record (there are cases where there are
> blanks
> so sometimes I need to do this a few times) and when I reach it tab back
> over
> to the same row in I and Ctrl-Shift Arrow Up and then Fill Down.
>
> Somehow this doesn't work very well when recorded as a macro, any
> suggestions appreciated.
>
> In my ideal world in fact once this script worked for a page I'd have a
> VBA
> script that would step through each page and apply the function and voila!

 | 
Pages: 1
Prev: Date Help
Next: frustrated excel newbie