-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
shtlog.cellslngnextrow
-
R
Tracking and logging changes to values within one column.
I have a piece of code (Which I got from this site) that tracks changes to cells within the worksheet. It works great except I'd like it to look a changes just within one column only, not the whole sheet. Anyone know of a way? Option Explicit Const intUsernameColumn = 1 Const intCellRefColumn...- Ronanm
- Thread
- Replies: 0
- Forum: Excel Questions
-
Record changes to Excel File
Morning all, I have worksheet with about 50+ sheets that is on our server. I need to be able to see who changed what cell and on what sheet and when. I found this code on here: Option Explicit Const intUsernameColumn = 1 Const intCellRefColumn = 2 Const intNewValueColumn = 3 Const...- Lensmeister
- Thread
- Replies: 6
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Unprotecting a sheet once a text box is selected
- Started by dpaton05
- Replies: 49
Can you unprotect a sheet once a text box is selected and then reprotect it again when it is unselected? I do not want to use active x text... -
OFFSET function with multiple table
- Started by xdenama
- Replies: 43
I have 100++ sheet (table) with same format with difference high (total row not fix, will change). How to combine all table (sheet) in one sheet... -
Question about Data Validation.
- Started by omairhe
- Replies: 24
Hello all, I find data validation to be a useful tool in excel 2019. In cell A2 if the value = A then allow both positive and negative integers... -
VLookup Or Other To Match Data.
- Started by fintail99
- Replies: 23
Hi there, I have data, as follows: Sheet1 A1: Name B1: 0.5 (this relates to total time, see Sheet2 below) C1: £25.00 (this relates to the total... -
Split a year range into one row per year
- Started by rameez788
- Replies: 21
Hi all, I am new on this forum. I have attached sample data, i need someone to help me convert the left side to how the data looks on the right... -
Combine 2 var into 1 string with & in between
- Started by bumbum2812
- Replies: 21
Hi Experts Please help me combine 2 var into 1 string with & in between. My data is from A1:A2 & i have below code to put in MsgBox...