136 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
At the moment I'm converting a project written in VBA to Delphi and have stumbled upon a problem with converting some Subs with Optional…
I have a short list of values from A1 through A10: A4 contains the string ab and A5 contains the formula: ="a" & "b"…
It is pretty much widely accepted that this is not 'best practise'. dim rng as range with thisworkbook '<~~ possibly set an external workbook…
How can I find the last row in a range of cells that hold a formula, where the result of the formula is an…
I am trying to get I/O as follows: Input : 123490 Output : BCDEJA Logic is simple: if strarr(i)=0,1,2,3,4,5,6,7,8,9 then strarr(i) should be =…
This equation: a+(13*b/c)+d+(12*e)-f+(g*h/i)=87 appears when trying to solve the maths puzzle for Vietnamese eight-year-olds that recently became viral all over the Internet. In…
I have an excel Userform with dynamically added checkboxes. I add the checkboxes early on with code that looks like this: Set chkBox =…
So at work I ran into this issue after I installed the most recent Windows 7 updates (including Microsoft Office 2010 updates) - the…
I was just wondering if you could help me better understand what .Cells(.Rows.Count,"A").End(xlUp).row does. I understand the portion before the .End part.
So I'm working on a project and I'm trying to get my VBA code to draw down the formula that's in cell M3 all…