Skip to main content
7 questions from the last 7 days
Newest Active Bountied Unanswered
-1 votes
1 answer
26 views

Long ago, the answer was "yes it is impossible", it was true Why 'Application.Calculation=[value]' statement in Excel VBA erases Clipboard Memory? But I have implemented a workaround....
UncleBob's user avatar
  • 49
-1 votes
0 answers
47 views

My problem is very similar to this post: Excel error dialogue still pops up even with error handling but the answers did not seem very relevant and so I wanted to re-ask, but I will give more of my ...
MisterMonster314's user avatar
  • 1
0 votes
2 answers
65 views

I'm using the SCAN() function to build a column vector in which the result depends on the value of each row of the input vector and the prior row of the output vector. The value/accumulator nature of ...
Thomas's user avatar
  • 1
3 votes
1 answer
118 views

I have a spreadsheet setup, where I loop through each row of the sheet, gathering a cell's data, combining it with a few other cells on other sheets to create a file path, and then copying the file/...
Metal's user avatar
  • 45
0 votes
1 answer
72 views

I'm trying to format text when it is on equal to the text of an adjacent cell. I create a custom format that looks like this: =$E2<>$F2 Excel does the formatting (just bolding) appropriately, ...
Tiggyboo's user avatar
  • 590
0 votes
0 answers
145 views

I have an Excel, and one of the cell values is a "Picture" Object. It is not a shape. How can export this picture to a file? This is my code, but it can't copy picture to Chart. Sub ...
mum's user avatar
  • 1,645
1 vote
4 answers
147 views

I'm trying to create a simple macro, and the solution is eluding me. Let's say I have a table: Header1 Header2 AAA 100 BBB 200 BBB 150 BBB 250 CCC 300 CCC 200 I want the formula to calculate so that ...
Collin Michels's user avatar
  • 21