reset certain cells to a default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i
1) put a button on on worksheet that when selected
2) will change any/all entered values of certain cells back to a default value
 
sub resetdefaults
range("a1")=1
range("a2")="Hi"
etc
end sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Default Cell value in changing environment 3
Data Validation - Complex Q 2
resettable, over-ridable, default cell values 0
Using countif on non-consecutive cells 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
find first occurance of certain value in grid 7
Making a cell a certain color for a value 2

Back
Top