VB Script or Macro? Not sure which.

[henry.haskins]

Never did any extensive work in Excel. I was a Lotus pro for years. I need help with the following:

I want to check a cell to see if it's empty. If it is I want to get the cell content of say, C31, and place it in the current cell. If it already contains data I want to move DOWN one and recheck until I get to the next empty cell to populate.

I know this is wrong but my thinking is

IF(ActiveCell="",=C31,DOWN)

But I'm thinking FOR loop will work better.

Additionally I need to know if it's better to do a VB script or a simple macro.

Thanx,
HH

[HaHoBe]

Hi, HH,

you choose the wrong forum to post your question (should have been General or VBA, maybe thread can be moved there by staff? TIA).

Automatic, for one cell only, for a range, which cell to copy from where? A lot of additional questions.

A macro which needs to be started by hand checking the contents of the presently active cell and adding the value form the cell above may look like this which doesnīt take care of Formulas in the cell returning "":

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Regarding VBScript or "simple" macro: this depends on whether you wan the code to run from within the Application Excel (this is what you may think of to be a macro) or from outside of Office/Excel. But that may only be answered from you as I canīt see what you really want to achieve and thus provide more detailed information.

Ciao,
Holger