• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA help required to run the code for all the used range rows

anishms

Member
Hi,
I'm just a beginner to VBA.
Required your help in attached my codes where I need to run the procedure based on every selection change in column H and J in all the used range rows.
Currently the code runs for a single row based on the manual run.
The last used row number is 99, but it will get increased
Thanks for your help in advance
 

Attachments

  • Risk Assessment Template.xlsb
    73.6 KB · Views: 3
I have done it with my limited knowledge but I have the following problems-
(1) The code is working even for the changes in columns "H" and "J" beyond the data set / current region.
(2) The code is working only in the first cell in case of multiple selection and deletion or paste values in columns "H" and "J"
Request somebody to help
 

Attachments

  • Risk Assessment Template.xlsb
    76.1 KB · Views: 3
Back
Top