VBA Loop - Horizontally & Vertically

[siva_satya]

I am trying to use loop both vertically and horizontally. how to use it both?

attached is the sample screenshotCODE_SCREENSHOT.jpgSCREENSHOT.jpg

Need your help on this.

Thanks.!

[6StringJazzer]

Welcome to the Forum siva_satya!

Where you are using

Please Login or Register  to view this content.

replace it with

Please Login or Register  to view this content.

That should be all that's necessary.

Notes for the future:

An image attachment has limited value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that.

Having your file allows us to see and experiment with your data, layout, formulas, code, and possibly attach a file with a completed solution. If you are looking for formulas to produce a desired result, it helps if you create a mock-up of what you want the result to look like. Otherwise we would have to build something from scratch, trying to guess what you want it to look like.

The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

You can also copy your code and paste it here as text, instead of showing a screenshot. When showing code, use code tags. There are two ways to add code tags. One is to select the code part of the text so it is highlighted, then press the "#" button in the edit controls. The other is to simply type in the tags:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

[BadlySpelledBuoy]

Hi and welcome

To answer your question you loop through the two dimensions something like this:

Please Login or Register  to view this content.

However, in this particular instance there is no need to loop as you can apply the formula and turn it into values in one go like this:

Please Login or Register  to view this content.

BSB

[siva_satya]

Thanks for your help.

I tried as suggested, but its not printing on desired cells.

In my opinion we need to change the second criterion "Range(f1)" in the formula. but not able to understand how.

I tried putting "cells(i , x)" in above criterion but it still didn't work. pls suggest what to write in highlighted section.

Capture1.JPG


Thanks!

[bakerman2]

Try this.

Please Login or Register  to view this content.