IRG

I am using the below code to do the following:

if I select any cell of A,D or E on any row (rows) then subsequently select Cells B:G on the same row (rows). it works , But the Problem If I select any whole column of (A,D or E) then excel hangs and not responding.
as always,any help will be appreciated.

Currently my code will track whether something is entered in an intersection area between the columns C:E and target row. So if I enter data into C2:E2 as long as all cells in that range have data, the worksheet change event will run.

The worksheet change event will capture the date, the name of the worksheet and a log of the entry. The issue is then if an area with more than one row is affected i.e C2:E6 it will capture the data as such on multiple rows depending on how many rows were affected. How do I adjust the code so when multiple rows are affected i.e C2:E6 it will capture multiple entries - C2:E2 - C3:E3 - C4:E4 - C5:E5 - C6-E6.

in the below code, if I select cell B* or cell C* , It subsequently selects range B*:G* on the same row. please, How to include non-contiguous cell (E) in Const cFirstRow As String = "B3:C3" .I tried "B3:C3,E3" but it gives me an error "Run-time error '1004': Method 'Range' of object '_Worksheet' failed.

Recently the VBA has stopped working. Normally it auto-populates today's date into column B when you enter data into column C and also populates today's date into column R when you enter data in column K.

I have recently messed around with protecting sheets and in the end, gave up and I have a feeling it has something to do with it.

It is odd because other areas of the VBA still work.

How can fix this so the VBA still auto-populates the columns it needs to?

I am currently trying to run this VBA code and keep getting the repeated error 'Invalid inside procedure'. Could anyone suggest what part of the code is wrong?

I have attempted to fault find however can not seem to find the root of the problem.

I'm trying to show data in my datatable in two ways:

1. the Parent rows have the data coming from a table that user should not edit
2. the Child row have the data coming from a table that user should edit

I'm passing them all through one array, in the Child Row, I am calling the data from the array index and then assign an Edit button to call an edit method.

The data shows in my Child Row correctly, but whenever I press on the edit button to call upon my modal, an error that says "Uncaught ReferenceError: d is not defined" and "Uncaught TypeError: Cannot read property '11' of undefined" appears.

Here is my Datatable JavaScript code: