$$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

2012-07-25 Thread Tony O
I am working on a spreadsheet with Excel 2007. I have the vba code to delete a line: Selection.Delete Shift:=xlUp I want to delete all rows that have the cells in column A that are blank and column B and column C for just those rows. I'm thinking that the code should look something like this,

$$Excel-Macros$$ Excel spell out word from number

2011-04-20 Thread Tony O
I have an Excel spreadsheet with a column of numbers. I would like each number to be spelled out, for example B1=4 C1=four B2=99 C2=ninety-nine. How would I go about this with a macro? -- -- Some important links f

$$Excel-Macros$$ Excel checkbox macro

2011-04-19 Thread Tony O
I would like to add a checkbox in column A for an Excel spreadsheet. When the checkbox is checked, you can type in columns B, C and D. If it is unchecked, the cells are locked. Ideally, I would like columns B, C and D to be grey if they are unchecked. How would I go about doing this? --