Multiply all cells in a row by variable

[captbluefin]

We are always looking for a way to do things more quickly.
We can do what we want to we can do one cell at a time with a loop. Very slow. It doesn't seem like we should have to work our way 1 cell at a time across a row. What we really want to do is select an entire row of cells and multiply the contents of each cell by the same Variable.

There are a hundred rows in the table ( I know not that big.) 20 columns wide. Just watching the macro run one cell at a time across a row, then down to the next row only to repeat cell by cell with an updated variable unique for that row makes us feel that we are not performing the operation in an efficient manner.

We didn't upload a sheet because so few cells are needed to demonstrate.

Note: We could enter the value for sngA into a cell prior to performing the calcultation

Please Login or Register  to view this content.

We know the above code is silly. We just want to give an idea of what we're trying (foolishly?) to do.

So.... The bottom line is whether or not working our way across the row cell by cell is the only way to accomplish the task. It just feels that there has to be a way to perform the multiplication across multiple cells at once .

As always - Thanks to all who look.

[6StringJazzer]

You can Copy, Paste Special with Multiply.

Please Login or Register  to view this content.

You did not show how sngA was derived, or used other than to set it to a constant, so I didn't use it.