Thank you very much for your suggestion. I will not be able to use this because when the cell is protected you will not be able to click on the cell.
Any other suggestions? Thank you for your comment.
I would like to allow a end user to update a excel spreadsheet by adding 1 to a cell. Please see the example below:
Example
On Monday the output was
A B C D E F
1 t1 9
2 t2 7
3
4 ttl 16
5
On Tuesday a User opens the file and adds one to "1B".
A B C D E...
I would like to allow end users to update some information but only to update the information by adding one at a time.
Example
On Monday the output was
A B C D E F
1 t1 9
2 t2 7
3
4 ttl 16
5
On Tuesday a User opens the file but it needs to add one to "1B". I would like...
Thank you very much cummings54 for taking the time a create the code for this task. I really appreciate it very much. It is working just fine. Thank you!
Thank you johnwm for your comments.
I would like to delete multiple ranges from multiple spreadsheets at once.
Example:
A workgroup has three Spreadsheets
Sheet 1:
delete the range from c4 to c53 and f4 to f53.
Sheet 2:
Delete the range from c62 to d84
Sheet 3:
Delete the range from a11 to d3 and f2 to k70
I would like to...
Mr. johnwm - Thank you once again for your help. It is working just fine. I would like to make a little modification as per your suggestion.
How do I prompt the user to provide the cell where the next number should go? OR how do I refer a cell for its location?
Example:
A B C D...
Johnwm - Thank you for your help.
Can you or anybody else, please explained the following code line by line?
Thank you in advance for your help:
Private Sub CommandButton1_Click()
Static a As Integer
Dim myRange As Range
Set myRange = ActiveSheet.Cells(6, (a + 3))
myRange.Value =...
I am automating a process using excel. I created a button to execute a couple of commands. What I would like to do is to copy a cell to the cell next to it every time the button is press.
Example:
A B C D E F
1 t1 10
2 t2 20
3
4 ttl 30
5
First time after you press the...
