Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula won't work on some computers
With frng ..Formula = "=TEXT(VLOOKUP(CONCATENATE(""00"",B4),'[ZRMA.xls]Format'!$A$2:$P$" & Workbooks("ZRMA").Sheets("Format").Range("A65536") .End(xlUp).Row & ",16,0),""0000000000"")" End With Hello. I worte an add-in for everyone in the company to use. 99% of the people that try it say it works perfectly. There are a few people that say it errors out on their machines. I went to one of them, and the above line of code is where it errors, specifically the piece of code: Workbooks("ZRMA").Sheets("Format").Range("A65536") .End(xlUp).Row If I replace that with a simple Range("A4:A1000") it works. Any idea why this doesn't work on some machines? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula won't work on some computers
There are actually only 65,535 rows in Excel. Make that change and you should
be OK... It is probably a service pack / version issue. I can honestly say I have never run accross this but I alway use 65,535... HTH "Steph" wrote: With frng ..Formula = "=TEXT(VLOOKUP(CONCATENATE(""00"",B4),'[ZRMA.xls]Format'!$A$2:$P$" & Workbooks("ZRMA").Sheets("Format").Range("A65536") .End(xlUp).Row & ",16,0),""0000000000"")" End With Hello. I worte an add-in for everyone in the company to use. 99% of the people that try it say it works perfectly. There are a few people that say it errors out on their machines. I went to one of them, and the above line of code is where it errors, specifically the piece of code: Workbooks("ZRMA").Sheets("Format").Range("A65536") .End(xlUp).Row If I replace that with a simple Range("A4:A1000") it works. Any idea why this doesn't work on some machines? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula won't work on some computers
Jim - There might be some situations where 65535 vs 65536 might solve
problems, but other than array formulas that cannot process entire columns I'm not sure what. Surely there are always 65,536 rows ? Steph - In the workbook with a problem, is there anything between the bottom row and where End(xlUp) is expected to arrive. Did you try a simplified version of the code, eg Range("A65536").Select Range("A65536").End(xlUp).Select Regards, Peter T "Jim Thomlinson" wrote in message ... There are actually only 65,535 rows in Excel. Make that change and you should be OK... It is probably a service pack / version issue. I can honestly say I have never run accross this but I alway use 65,535... HTH "Steph" wrote: With frng ..Formula = "=TEXT(VLOOKUP(CONCATENATE(""00"",B4),'[ZRMA.xls]Format'!$A$2:$P$" & Workbooks("ZRMA").Sheets("Format").Range("A65536") .End(xlUp).Row & ",16,0),""0000000000"")" End With Hello. I worte an add-in for everyone in the company to use. 99% of the people that try it say it works perfectly. There are a few people that say it errors out on their machines. I went to one of them, and the above line of code is where it errors, specifically the piece of code: Workbooks("ZRMA").Sheets("Format").Range("A65536") .End(xlUp).Row If I replace that with a simple Range("A4:A1000") it works. Any idea why this doesn't work on some machines? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
Formula only works on some computers | Excel Worksheet Functions | |||
Saving custom toolbars with macros to work on other computers | Excel Discussion (Misc queries) | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
How can I link excel spreadsheets that work on other computers | Excel Discussion (Misc queries) |