Code running in wrong sheet

**cgeistman** · 07-30-2008, 04:32 PM

I am trying to copy a row of cells down to the last entry of a corresponding cell. i.e. like when you double click on the bottom right hand corner of a cell and it copies downward until there are no values around it.

I can get the code to run on Sheet 1 but I need it to work on Sheet 2 and can't figure out how to do that. Basically it does what I want just using the wrong sheet, (But correct cell references).

Here is the entirety of the code, I've made the troublesome part red:

Please Login or Register  to view this content.

Thanks in advance for the help!

**SOS** · 07-30-2008, 04:59 PM

Hi cgeistman,

Perhaps you just need to select the sheet "Compacted JIT" before your code in red:

Please Login or Register  to view this content.

**cgeistman** · 07-30-2008, 05:17 PM

I get a 400 Error with that...

**SOS** · 07-30-2008, 05:47 PM

Hi cgeistman,

I put your code into a new workbook, renamed "Sheet2" to "Compacted JIT", put some data (first numerical then alpha along with some " ") into Column A of Sheet 1, then put a simple formula in B3, C3, D3 of "Compacted JIT" (ie "=A3"), stepped through the macro and it appeared to work - deleting the blanks, copying the values to "Compacted JIT", and filling in the formulae.

Unless I'm doing something different I can't see why you still get the error.

**cgeistman** · 07-31-2008, 03:40 PM

I can't get it to work, I keep getting the 400 error.

I wonder if it has anything to do with my formulas?

**SOS** · 07-31-2008, 04:39 PM

Hi cgeistman,

Perhaps you could post one or two of the formulae for us to have a look at (I presume they are in "Compacted JIT") and see if anyone can help out