Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
select specific sheet and cell
I have an Excel workbook which has 5 worksheets. I would like to add some VBA
code so that whenever the workbook is opened, we automatically go to Sheet 3, Cell F6. And in which category should I write this code - Sheet1, 2, 3, 4, or 5 or This Workbook? Can anyone help please |
#2
Posted to microsoft.public.excel.programming,microsoft.public.word.mailmerge.fields
|
|||
|
|||
select specific sheet and cell
You will be more likely to receive a response to this if you ask in the
microsoft.public.excel.programming newsgroup to which I have cross posted this response. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Yendorian" wrote in message ... I have an Excel workbook which has 5 worksheets. I would like to add some VBA code so that whenever the workbook is opened, we automatically go to Sheet 3, Cell F6. And in which category should I write this code - Sheet1, 2, 3, 4, or 5 or This Workbook? Can anyone help please |
#3
Posted to microsoft.public.excel.programming,microsoft.public.word.mailmerge.fields
|
|||
|
|||
select specific sheet and cell
Put in the ThisWorkbook code module.
Private Sub Workbook_Open() Worksheets("Sheet3").Activate Range("F6").Activate End Sub "Doug Robbins - Word MVP" wrote: You will be more likely to receive a response to this if you ask in the microsoft.public.excel.programming newsgroup to which I have cross posted this response. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Yendorian" wrote in message ... I have an Excel workbook which has 5 worksheets. I would like to add some VBA code so that whenever the workbook is opened, we automatically go to Sheet 3, Cell F6. And in which category should I write this code - Sheet1, 2, 3, 4, or 5 or This Workbook? Can anyone help please |
#4
Posted to microsoft.public.excel.programming,microsoft.public.word.mailmerge.fields
|
|||
|
|||
select specific sheet and cell
Sorry about that. Problem now solved. Thanks
"Doug Robbins - Word MVP" wrote: You will be more likely to receive a response to this if you ask in the microsoft.public.excel.programming newsgroup to which I have cross posted this response. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Yendorian" wrote in message ... I have an Excel workbook which has 5 worksheets. I would like to add some VBA code so that whenever the workbook is opened, we automatically go to Sheet 3, Cell F6. And in which category should I write this code - Sheet1, 2, 3, 4, or 5 or This Workbook? Can anyone help please |
#5
Posted to microsoft.public.excel.programming,microsoft.public.word.mailmerge.fields
|
|||
|
|||
select specific sheet and cell
Thanks very much for this. It's easy when you know how!!
"JLGWhiz" wrote: Put in the ThisWorkbook code module. Private Sub Workbook_Open() Worksheets("Sheet3").Activate Range("F6").Activate End Sub "Doug Robbins - Word MVP" wrote: You will be more likely to receive a response to this if you ask in the microsoft.public.excel.programming newsgroup to which I have cross posted this response. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Yendorian" wrote in message ... I have an Excel workbook which has 5 worksheets. I would like to add some VBA code so that whenever the workbook is opened, we automatically go to Sheet 3, Cell F6. And in which category should I write this code - Sheet1, 2, 3, 4, or 5 or This Workbook? Can anyone help please |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to print from specific table cell? | Tables | |||
Select specific cells in table via macro | Microsoft Word Help | |||
Use drop down lists to select specific criteria | Microsoft Word Help | |||
How do I select specific information from an imported table | Tables | |||
How do I select specific data from an imported document | Microsoft Word Help |