Loop thru Column A for last row Loop thru column B for cells to paste to

benntw

Board Regular
Joined
Feb 17, 2014
Messages
222
Office Version
  1. 365
Platform
  1. Windows
I'm struck on this one. I have data in column A to loop thru to find last row. In column B I have data off and on. What I am trying to do is use column A to find last row and column B as a secondary loop to use to paste formulas various columns. There are certain rows that change that I do not want the formula to paste into. I am copying the formula from row 1 and starting the pasting in row 14. Hope someone can help on this one. Thank you.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Dim TotalRowCounts As Long
TotalRowCounts = ActiveSheet.Range("A14", ActiveSheet.Range("A14").End(xlDown)).Rows.Count + 13

I was trying to use this from another code I had just to have my first loop. I tried to duplicate this loop and change the range and it wouldn't work. This is the starting point of the data. The second loop I need to reference the first loop for last row, but only populate the formulas in the same row that column B has data in different rows and can change at any given point. Also my overall range of rows can change . That's why I have column A. After I copy and insert a row column A data never changes.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top