Programming

Workbooks.Open with a network path
Hello I'm trying to do a Set SrcWrkBook = Workbooks.Open(\\networkdrive\ folder one\ folder two\filename.XLS, True, True) I assume the white spaces and perhaps the \\ are giving me issues. How do I get around this? ... 14 Apr 2010 12:12

Active.Paste Error
What is an Active.Paste error in an Excel macro and how do I make it go away? I am working with two lists in a spreadsheet, side-by-side. My task is to move to cell A1, filter to the row I need in column A, copy the corresponding value from column B, release the filter, and move to the first open cell in the ... 14 Apr 2010 12:12

Macro to Pivot data in each sheet within a workbook
Hi , What code would I need to create an individual Pivot for data in each sheet within a workbook , all sheets have the same headings but different number of rows and all pivots will be the same . or If I create a master pivot from the data in all the worksheets , could I break it up so that each page field is a... 14 Apr 2010 12:12

copy rows with values - not formulas
Hi First step is no problem: in Sheet1 col AI this formula is inserted with VB to add age groups =OM(OCH(Age>=0;Age<7);"a. 0-6";OM(OCH(Age>6;Age<16);"b. 7-15";OM(OCH(Age>15;Age<26);"c. 16-25";OM(OCH(Age>25);"d. 26-";"")))) Col is autofilled to last used row. In next step I loop thru these rows to find cert... 14 Apr 2010 11:04

Dynamic view of data based on cell content
Theoretically possible. you can write a macro to autofilter first sheet with respect to the name in the second sheet and copy the visible cells to sheet2 at the appropriate rows by inserting rows above the cell containing names it depends upon the configuration of the two sheets. Wes_A wrote: Dynamic view ... 14 Apr 2010 08:47

Fix the size of form controls in a worksheet
I have inserted some form controls like the command buttom in a workbook. I want to make the size of the controls fix. So that if i insert and or delete the rows in the sheets, i would be able to maintain the same size of the controls. If the rows are deleted, sometimes the forms are even hidden or diminished. ... 14 Apr 2010 07:41

Disabling copy/cut/paste for shapes
Hi, I've noticed in Excel 2007 that the code available in several topics to enable/disable copy/cut functions in all toolbars doesn't work for objects such as shapes, charts ... Is that a feature or a bug? Has anyone found a workaround? Thanks, MrT ... 14 Apr 2010 12:12

Working with a worksheet that is not the active worksheet
How can I make this code work on my worksheet named February, when it is not the active worksheet? Sub BlankWeeks() ' ' Macro2 Macro ' ' If Range("C184").Value = "" Then Rows("184:228").Hidden = True End If If Range("C184").Value <> "" Then Rows("184:228").Hidden = False ... 14 Apr 2010 11:04

How to write a macro to hide an entire row
Hello guys, I would like to write a macro that would hide an entire row if the cells value in that column is equal to 0. Someting like this: A B C 1 20000 2 0 - if c2 = 0 then hide entire row 3 20000 Thank you for your help. José ... 14 Apr 2010 08:47

Countif number between x and y
Have a column of figures and want to countif the value in cell falls between x or y That is countif(e:e, >5 or <10) ... 14 Apr 2010 04:25