-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
active sheet problem
-
Q
Different ActiveWorkbook and Different ActiveSheet
I am writing a macro which is editing data in a different excel file. Let, Excel_with_Macro be the excel file where I am writing the macro Sheet1_EwM be the sheet of excel file Excel_with_Macro Excel_2b_edited be the excel whose data I am editing data_E2bE be the sheet of Excel_2b_Edited and...- QuestionBaker
- Thread
- active sheet active sheet problem charts different file macro
- Replies: 8
- Forum: Excel Questions
-
J
Code not looping through multiple sheets as intended - VBA
Hello, I am using the following code to copy/paste a range from one worksheet to multiple sheets. But, my code is only pasting the range onto the sheet that is currently open. Any thoughts on how to get it to copy paste to all sheets that begin with "Labor BOE"? Here is the line in my code...- jwb1012
- Thread
- active sheet problem copy & paste range in vba error multiple worksheets
- Replies: 11
- Forum: Excel Questions
-
C
Sending an Active Worksheet with VBA
Hi all, I am using a modified version of the popular code from Ron de Bruin and all is working fine...... in Excel 2003 I manage around 80 workbooks for a team of 18 Project managers and have included a button on the required sheet in their master workbook to send it to my offices email...- ChrisBurns
- Thread
- active sheet problem remove external links sendmail
- Replies: 4
- Forum: Excel Questions
-
Copy WS to new WB and use original WB sheet names
Hi, I am trying to copy worksheets with specific names to a new workbook. I want to copy the worksheet from a master template workbook. My problem is that it creates a correctly named worksheet in a new workbook and then searches that new workbook for the sheet template name (which does not...- Prevost
- Thread
- active sheet problem copy worksheet vba new workbook
- Replies: 1
- Forum: Excel Questions
-
J
for each ActiveSheet.Range problem
Hi all, i have problem with macro: Dim iCell As Range count = 1 last = ActiveSheet.Range("a3").End(xlDown).Select For Each iCell In ActiveSheet.Range("a3", ActiveSheet.Range("a3").End(xlDown)).Select iCell.Value = count count = count + 1 Next...- Johndd
- Thread
- active sheet problem
- Replies: 4
- Forum: Excel Questions
-
B
Transferring Data from one sheet to another
<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1><!-- / icon and title --><!-- message --> With some collegues we created a worksbook in order to calculate the final grades that a teacher needs for the students in his/her class. It starts with a sheet in which the teacher identifies...- Brutium
- Thread
- active sheet problem transfer data visible range in vba
- Replies: 0
- Forum: Excel Questions
-
E
Macro & related sheet names problem
<TABLE style="WIDTH: 317pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=423><COLGROUP><COL style="WIDTH: 317pt; mso-width-source: userset; mso-width-alt: 15469" width=423><TBODY><TR style="HEIGHT: 217.5pt" height=290><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT...- engbhs
- Thread
- active sheet problem excel macro macro help macro problem sheet name in macro
- Replies: 0
- Forum: Excel Questions
-
S
ActiveSheet is not the ActiveSheet?
I'm trying to use a button in one workbook to open another Excel file, copy data from that file into an array, and paste some of the array data back into the original file (with the button) but on a different sheet than the sheet where the button is located. In the past, I've had no problems...- sjc
- Thread
- active sheet problem slow process
- Replies: 11
- Forum: Excel Questions
