Programming

data splitting
hello.. I have a column of data which i want to split into 2 other columns. For example, A B C ABC SCH, CDE SCH ABC SCH CDE SCH FGH SCH, FGH SCH - IJK SCH, LMN SCH IJK SCH ... 20 Apr 2010 06:13

2007 Customui - is it possible to control the visbility of a "grou
I'm looking to have a "group" displayed only when "Sheet1" is active. Is this possible? My UI code is: ------------------------------------------------------------------------------- <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon> <tabs> <tab idMso="TabHome"> <group id="RGroup" l... 20 Apr 2010 01:03

How to set macro to run every 15 minutes?
Does anyone have any suggestions on how to set macro to run every 15 minutes? Thanks in advance for any suggestions Eric ... 21 Apr 2010 08:26

Adding code
Hello I have this code (below) and I wish to add another Interior.ColorIndex 5 and another Value "Media". Is this possible? Option Explicit Dim nextSecond Sub startFlashing() flashCell End Sub Sub stopFlashing() On Error Resume Next Application.OnTime nextSecond, "flashCell", , Fals... 19 Apr 2010 21:56

A seemingly simple problem for VBA
A seemingly simple problem for VBA Hi, I am trying to solve the following problem using Excel VBA. I have two EXCEL worksheets. Each sheet contains data of the following type. Account number, amounts for Jan, Feb, March etc There are about 100 accounts on each worksheet. There are about 20 accounts ... 20 Apr 2010 14:30

macro stopping
All of my macros are pausing at various points. Is there a control somewhere that I may have hit by mistake? Is there any way to stop it from doing this? It gives me the option to continue, but I don't want to have to keep pressing continue. ... 19 Apr 2010 17:48

Sheet name changing dilemma
So I have a workbook with 9 sheets of data and 9 more sheets of charts and graphs that feed off of that data. The nine sheets of data rotate each week. Week 1 of data rolls off and a new week 9 of data rolls on. I'm working on do this via a macro. Here's the problem: the two options I know of are to copy and p... 19 Apr 2010 14:41

copy rows in range if data in first cell
I need to select from a range of rows - only those having data (formula result) in the first cell. There will be some rows without data in the first cell but they would contain a formula - these shoudl not be selected for copy. I want to select and copy all the rows having data in the first cell in order to past... 20 Apr 2010 03:07

Deleting rows when cell has "#DIV/0!" error
Hi, I'm currently using this code to delete rows with balnk cells. However, i have changes the formatting of my sheet and the cells are no longer blank they have the "#DIV/0!" error. How can I delete the entire row when the cell in column D has that value? Sub DeleteRowsIfDIsBlank() With payrollsht ... 19 Apr 2010 15:43

disable clipboard alerts
Is there a way to disable the clipboard warning or to change it's size threshold? ... 19 Apr 2010 11:34