Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mike1504

    Excel select and clear range using variable for range name

    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.
  2. mike1504

    Excel select and clear range using variable for range name

    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...
  3. mike1504

    Excel select and clear range using variable for range name

    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...
  4. mike1504

    Excel select and clear range using variable for range name

    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...
  5. mike1504

    Excel select and clear range using variable for range name

    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.
  6. mike1504

    Excel select and clear range using variable for range name

    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...
  7. mike1504

    Excel select and clear range using variable for range name

    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 =...
  8. mike1504

    Excel select and clear range using variable for range name

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

    Excel select and clear range using variable for range name

    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...

Part and Inventory Search

Back
Top