Sub NewSheet()
'
' NewSheet Macro
'
'
Sheets("Timeshe et").Select
...
'
' NewSheet Macro
'
'
Sheets("Timeshe et").Select
DWHTHS
Last Activity: Aug 11 '09, 02:04 PM
Joined: Jul 9 '08
Location:
-
Hi MTB, thanks for the reply. The cell is within the new sheet, however, the cell value needs to be ammended as part of the macro, then I want the new value to be the sheet name. The code from the Macro is below, could you tell me where I need to insert the code? The cell I am trying to use is C7. Many thanks for your help.
-
Rename sheet name as a value in a cell
Hello, this is a VBA query relating to Microsoft Excel 2007.
I am trying to run a macro that copies the current sheet and deletes some of the content to provide a new blank sheet.
Ideally I want this to use a value that is shown in a cell within the new sheet. I had tried to acheive this by copying the cells contents and then pasting as a value within a macro, however this worked on the first sheet but the second time... -
Hello, many thanks for the advice, your way loooks better/easier than what I was trying to do!
Dave...Leave a comment:
-
Unbound data entry for more than 1 table
Hello, I am quite new to access, but seem to be getting there now. I am producing a database, and I want to make a data entry form that is not bound to a table, as I do not want half completed records to be saved to the database.
I have used a append query for where I have information going into one table, and this worked great.
What I am trying to do now though, is have a data entry form for a main table 1, as well...
No activity results to display
Leave a comment: