Search results for query: *

Thank you Skip. When I went back and started over. I started with fewer subs and names. I got the range name to transfer by variable. Appears I did have quite a bit of typo's in the last spread sheet. Just not good at seeing them yet in VB. The spreadsheet makes it pretty easy to see them.

The markers for the start of each range are defined by a fixed reference to a single cell as follows: extractbrand ='Tile Data'!$B$1014 extractclass ='Tile Data'!$D$1014 extractcolor ='Tile Data'!$E$1014 extractstyle ='Tile Data'!$C$1014 tiledb ='Tile Data'!$B$3 The ranges are defined by...

The ranges are defined in the excel workbook as follows: branddbrange =OFFSET(tiledb,0,0,COUNTA('Tile Data'!$B$3:E$1003)) brandvalrange =OFFSET(extractbrand,0,0,COUNTA('Tile Data'!$B$1014:$B$2014),1) classvalrange =OFFSET(extractclass,0,0,COUNTA('Tile Data'!$D$1014:$D$2014),1) colorvalrange...

Thanks Skip, but I had aleady caught the variable. It still gave the 1004 _global... error. When I have time to play, I may set up a sheet to just experiment on this issue. I think I saw it work on one worksheet (called from the open workbook event) then when I called the sub from another...

Thanks Skip. Still I have no good result. I have decide to make 10 different calls. Takes lots less time to program in the long run.

1)The ranges are named in the excel spreadsheet. they are defined with an excel offset(Ref,col,row,Height,width) statement that makes them dynamic, so that the ranges are not always the same size, but each always has a marker for it's top left cell. 2) At one point I am calling clear_range...

Thanks Adoozer for your response. I tried to activate the sheet and then the range. I'm still getting the same problem. I think it has to do with passing "FredTheRange" into the argument list as a string variable. when i use "FredTheRange" it clears the range, but when I set a variable =...

I posted the error line of code wrong. it should have read range(clearrange).select '<--error occurs here

I am trying to clear a range by selecting it thru a variable. when I get to the line which reads Range (tiledbrange) select I get : runtime error 1004 Method 'range' of object '_global' failed. The range is defined in the excel spreadsheet and is of the nature...