Compile error variable not defined

**RAJESH SHAH** · 01-08-2023, 01:30 AM

Hello code experts
I am trying to resize the cells of columns E to L with A after filling the rows with some formulas posted after converting them into code.
I have just compared a previous code and tried to do the same with this code. I am not able to understand how to define a variable like I am getting a compile error variable not defined. I need your expetise to define the variable and make this code running without error.
Please note: A similar code is also in the workbook which is working but with a different range of columns.
https://drive.google.com/file/d/1ws1...usp=share_link

**RAJESH SHAH** · 01-08-2023, 01:33 AM

I was able to copy the link to the original thread.

**PCI** · 01-08-2023, 06:56 AM

What, where, is the issue, there is NO compilation error ...?

**jindon** · 01-08-2023, 07:09 AM

Please Login or Register  to view this content.

What are you trying to do?
x = 0 so can not Resize the range since it must be 1 or greater.
temp = Empty, so no idea...

**RAJESH SHAH** · 01-08-2023, 07:15 AM

I am trying to fill cells from E2 to L2 by resizing it with column A. But I am getting a runtime error 1004.

**jindon** · 01-08-2023, 07:17 AM

As I said x = 0, temp = Empty means no array, so that block means nothing and impossible.

**RAJESH SHAH** · 01-08-2023, 07:17 AM

Run only the Extract B2C code seperately. That is the one which is not working. The extract B2B is working and I copied the code and tried to create a likewise code Extract B2C. But failed to do so.

**jindon** · 01-08-2023, 07:20 AM

That is the part of that procedure "DExtractB2C",,, I'm out and good luck.

**RAJESH SHAH** · 01-08-2023, 07:20 AM

But the first part of the code has printed the values in columns A B C and D. I am just trying to resize E to L with A. How do I correct this.?

**RAJESH SHAH** · 01-08-2023, 07:22 AM

By the time I was able to share the file, I was able to correct the compile error. Now the error is run time error 1004.

**RAJESH SHAH** · 01-08-2023, 07:56 AM

Guys, I am no coder. I am just playing with codes and trying out new things. I get your expertise to correct my code and make it right.

**RAJESH SHAH** · 01-08-2023, 10:06 AM

Shared the thread in other forum hopefully for some solution.
https://forum.ozgrid.com/forum/index...ect-this-code/

Compile error variable not defined

LinkBack

Thread Tools

Rate This Thread

Display

Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Re: Compile error variable not defined

Thread Information

Users Browsing this Thread

Similar Threads

Compile error: Variable not defined

Compile error: variable not defined

Compile error Variable not defined...?

[SOLVED] Compile Error: Variable Not Defined

Compile error variable not defined

Compile error on variable (not defined)

[SOLVED] Compile error, variable not defined

Bookmarks

Bookmarks

Posting Permissions