Inserting Rows between 2 values

JCScoobyRS

JCScoobyRS

Board Regular
Joined
Sep 17, 2002
Messages
102
I have a worksheet right now that will look between two rows, A73 and A83, and look for changes. Row A73:1 has been names ASSEMBBEGIN and the folowing row A74:1 has been names ASSEMBTOTAL. Is it possible to modify my macro to look up these two values and look for changes in between them instead of predefining it to 10 rows, A73-A83? Thanks, Jeremy
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
You must log in or register to reply here.

Similar threads

M
  • Question Question
Sum together the larger amount of two ranges by row
Replies
3
Views
68
Cubist
Cubist
K
  • Solved
Is there a way to create a Macro to insert a blank row based on the change in cell value in multiple columns?
2
Replies
13
Views
542
kokoanutt
K
W
  • Solved
VBA - Match two values from Table1 to two in Table2 and move/align
2
Replies
15
Views
229
Welshy1491
W
J
  • Solved
Selecting individual cells
Replies
9
Views
227
jstuexcel
J
T
  • Solved
Move cursor to a specific cell after data has been entered
Replies
4
Views
323
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,415
Messages
6,178,499
Members
452,853
Latest member
philipnjk64

Share this page

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