Vletm,
Thank you for your response, unfortunately its not exactly what I was looking for, but i like what you were able to do, it does provide an alternate way to look at it.
Attached is the "result" I was hoping to get to, but i would like each level represented, not as an entire row like I...
Each level is the same height but stacked on each other to represent a racking system, and the color would be to represent the values based on a scale, maybe 3 tiered conditional formatting. the first numbers represent the bin row numbers, the Alpha character represent the height levels, A being...
I want it in a 3d graph so I can rotate it to see the variations, this is an example of what I want it to look like, but my description above is more complete layout
I am trying to create a visualization of a warehouse showing areas of high volume that I want to color code, Red for high volume through blue for low volume, but I want to represent this in a 3d format so I can see a each location in its respective rack in its respective row with about 10 bin...
I am trying to scatter plot measurements of angles, I have 360 degrees listed on the columns and I have 243,000 measurements, each measurement is placed depending on the degree it falls, however, because of this amount of data, I can't graph more tan 255 columns or rows. does anyone know how I...
I figured it out. so simple. when I protect my sheets the change event that it was linked to was locked under the protection, so excel couldn't select the cell until it was unlocked. so thanks for your support in trying to help me.
I can do that on Monday. I hope you can help. it's a really big deal that its not working, it worked before but now its not. so I really appreciate it.
I have a hyperlink in my worksheet. the hyperlink goes to a website, when it goes to the website I can search for an address. I have the address 5 columns to the left of this hyperlink, I want to be able to allow the person to select the hyperlink but have vba copy the address, so when they go...
sorry, I can't do that. I initially created to code on the first sheet. it was a change event in cell F2. I then copied the exact code and pasted on a different sheet to perform the exact same thing, but on this sheet it won't run but once and then the change event doesn't seem to work. that...
I am using a scanner to scan barcodes on a list (items I am trying to find). I created a worksheet function using case select when case = $F$2, so when the user scans the barcode when the cell F1 is selected, it will execute. every barcode I see I scan and gotes through each one, one after the...
I want to be able to put in a list of addresses, they show up as an interactive icon in a map of the USA. then I want to be able to see the icon change based on some KPIs and then click on the icon to get more information. Is this possible with VBA and perhaps google maps. I need the map to be...
Yes, i know the routine; however, i am absolutely not allow to upload or download anything from the internet with out IT security analyzing and approving. so that is not an option for me.
I added the wait code between the two and getting the same error in same place; no debug code or error code, just stops the vba and the VBA application is not opened either, just literally nothing.
a) There is no delay
b)118 kb is the size, the code does require the file being opened and pasted to to be saved, currently loops 9 times.
c) inserted DoEvents in both locations, one at a time and same thing happens. Stops in same location and ends the code, not debugg error, just stops.