j10

Hello everyone, after long back and forth I have copied the code into a toggle button. Works well, except for the columns. The toggle button is set to three states, Tri - State. As you have noticed, my VBA knowledge is not the best ... in a nutshell :-) My question from the whole ... How can I...

Can anyone help me please, I have to arrays of numbers each array has 12 numbers, the numbers in array 1 are equal to a numeric value in aray 2. Example cell j10=1 if cell j10 =1 then cell h10=4373 cell j11=5 if cell j10 =5 then cell h11=600 and so on for j10:j22 and H10:h22. I tried to write...

I have a fx in H10. In J10 is where my formatting is to take place. the C/F is as follows in J10: =H12>0 Once it changes to a value >0, I want the cell to change to a color. But I don't want the color to show until there's a value in H. Right now the cell will still be "green" because it sees...

say i have a sales invoice, which has inv no. in range d10, date in j10 and sales item list in the following range b19:n48. can i copy this live data from an active workbook to another workbook (which may be active or not). also the sales item list has 30 rows, but data can be in only 1 row or...