workrng

I used this VBA application to add the date when I update a cell. But now I can't protect the sheet? If I protect the sheet the VBA application does not work? Is there anyway to protect the sheet and use VBA? <code class="vb keyword" style="white-space: nowrap; padding: 0px !important...

Here is the code I'm using to double space but for some reason it doens't work when my data is in a table. Let me add that this data is coming from a microsoft query. Sub InsertBlankRows() Dim Rng As Range Dim WorkRng As Range Dim FirstRow As Integer, xRows As Integer, xCols As Integer On...

Hello, I would like to have the below code run twice within the same worksheet. As seen now, it's set to place a timestamp in a cell four columns to the left of column "S". I would like to run this a second time and it would need to be 7 columns to the left of column "U". Thanks in advance...

I need assistance merging the two macros below together. The goal is to have a date/time modified displayed in column K when data is entered in column J, as well as a date/time modified displayed in column M when data is entered in column L. I already have to two setup independent but am unsure...

I have other codes on other sheets and my issue is the set "set WorkRng = Intersect(Application.ActiveSheet.Range("B:B), Target)" Is the issue because I need to make this code specific to one sheet and not just "ActiveSheet?" <tbody style="border-radius: 0px !important; background: none...

I need some help writing a macro that will combine duplicate entries and delete out one of the entries. Please see table below: In below table I would like to combine the two entries for 123 on one row displaying all three reasons. I have a lot of data, so it would need to be a macro. Any help...

Hi All, I am not much savvy with the VBA Code building. I have googled below code and modified as my need. But when I have protected the worksheet(Unlocked the target cells) and reopen the excel, I got an error that due to security issue macro is disabled. And then it didn't capture the time...

OK, so bit of a tricky one for me anyway. I have a list of data that has zero blank rows separating different values: <tbody> 100 100 200 200 300 300 </tbody> Now I've found this code to compare the cells above and...

Hello, New to this forum and could not really find an answer for some reason related to this, but hopefully someone could help on this one. I am sure it is an easy solution, but I am not getting any luck. I am trying to get these two codes to work simultaneously but only work when when they...

Hi, I want to create a VBA Macro to show me when there is a change in any cell in a certain range. I found the below and amended to suit my sheet , but it does the trick , but it only works for 1 column not a range of columns .. as you can see the offset is -3 .. and it shows date and time 3...

Hi Everyone, I would like to ask for some help writing a few lines of codes to speed up the generation of a few reports. I would like to have the code delete a column if the column only contains text. So far I have the following code I have created through a bit of research online Dim...

Hi Guys, Need your help. I need to unmerged Column A & B using this formula, can u please help me out. While using this code, it duplicates other columns available in the sheet Sub UnMergeSameCell() 'Upadateby20131127 Dim Rng As Range, xCell As Range xTitleId = "KutoolsforExcel" Set WorkRng...