Very Simple Looping Question

[alnr]

Hi-
I obviously don't know any VBA, but need to know how to do this simple task. I need to select a cell in a row, activate it (F2 for example), hit enter, move down to the next cell, and do the same thing down to a specific row number.
Any help would be greatly appreciated.
Thanks
Al

 

[Norie]

alnr

Could you actually post a sample of the data?

Where is the data coming from? Is it numeric or text?

Are there any 'special' characters involved?

Have you considered 'fixing' the formula?

 

[im2bz2p345]

alnr

Could you actually post a sample of the data?

Where is the data coming from? Is it numeric or text?

Are there any 'special' characters involved?

Have you considered 'fixing' the formula?

Dear Norie,

Please see my sample data in the thread. Alnr and I are after a similar fix. I have provided a very simple data set for you to test any code on.

Thanks,

~ Busypee

 

[im2bz2p345]

So I recorded a macro myself (based on my sample excel data) and here is what I got:

Sub AutoCalc()
'
' AutoCalc Macro
' Auto calculates cell selected
'
' Keyboard Shortcut: Ctrl+Shift+D
'
    Range("F1").Select
    ActiveCell.FormulaR1C1 = "=46+67"
    Range("F2").Select
    ActiveCell.FormulaR1C1 = "=46+68"
    Range("F3").Select
    ActiveCell.FormulaR1C1 = "=46+69"
    Range("F4").Select
    ActiveCell.FormulaR1C1 = "=46+70"
    Range("F5").Select
    ActiveCell.FormulaR1C1 = "=46+71"
    Range("F6").Select
    ActiveCell.FormulaR1C1 = "=46+72"
    Range("F7").Select
    ActiveCell.FormulaR1C1 = "=46+73"
    Range("F8").Select
    ActiveCell.FormulaR1C1 = "=46+74"
    Range("F9").Select
    ActiveCell.FormulaR1C1 = "=46+75"
    Range("F10").Select
    ActiveCell.FormulaR1C1 = "=46+76"
    Range("F11").Select
    ActiveCell.FormulaR1C1 = "=46+77"
    Range("F12").Select
End Sub

Could this macro coding be edited so that the user can specify the range of cells he/she wants re-calcuated?

Hope this helps,

~ Busypee

 

[Norie]

busypee

I was actually addressing the OP, alnr.

What are you actually trying to do?

It seems rather different than the topic of this thread.

 

[im2bz2p345]

busypee

I was actually addressing the OP, alnr.

What are you actually trying to do?

It seems rather different than the topic of this thread.

Dear Norie,

I know that you were addressing the OP, that's why I wrote:

Alnr and I are after a similar fix.

I think you may need to go back and re-read the topic because we are both trying to:

find a way to re-calculate every cell's data.. without having to select each individual cell, hit F2, and then press Enter.

Please go back and read my earlier posts for further clarification. Thanks.

~ Busypee

 

[Norie]

Eh, I have read the posts.

And as far as I can see the OP's problem is data not stored as required eg numbers as text, dates as text etc

 

[wsjackman]

select column f
goto find and replace

find what =
replace with =

 

[wsjackman]

Re: Very Simple Looping Question
<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1>select column f
goto find and replace

find what =
replace with =

was actually the solution to im2bz2p345's problem

for anlr
if your data is numbers,
put 1 in an empty cell and copy
select your data and paste special multiply

alternately you can use text to column

 

[im2bz2p345]

Eh, I have read the posts.

And as far as I can see the OP's problem is data not stored as required eg numbers as text, dates as text etc

Oh, I apologize for the confusion Norie. I was thinking he had a similar problem than mine. Thanks for the clarification.

Re: Very Simple Looping Question

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1>select column f
goto find and replace

find what =
replace with =

was actually the solution to im2bz2p345's problem

Thank you wsjackman!! This works great. I'll be sure to use it when I encounter this problem again.


~ Busypee