For next loop for range names

[tamilvendhan]

Hi all,

I have macro like below

Sub Match_fft()
Dim a As Range

Set a = ActiveSheet.Range("FFT1")
' i have to do some computation

Set a = ActiveSheet.Range("FFT2")
' i have to do some computation SAME AS ABOVE

Set a = ActiveSheet.Range("FFT3")
' i have to do some computation SAME AS ABOVE

Set a = ActiveSheet.Range("FFT4")
' i have to do some computation SAME AS ABOVE

End sub

is it possible to use "for next" loop to calculate from FFT1 to FFT4?


Thanks in advance

[rylo]

Hi

for i = 1 to 4
set a = activesheet.range("FFT" & i)
next i

rylo

[tamilvendhan]

Thanks a lot for QUICK REPLY