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,
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
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?
--