Search results for query: *

Thanks! The 13 was a typo - it was the "wrap" that I didn't realize!

I'm trying to put a line break in an excel formula in a spreadsheet. Ex. ="Hello"&Char(13)&"World" The problem is that the return shows up as a box symbol (ie does not insert the line). Is there anyway to type the formula such that excel recognizes the line break? Thanks, Christine.

In excel, is it possible to hide a group box (in this case, used to group option buttons) on a form without also hiding its contents?

I have a macro which opens new Word documents from different templates. With some of the files, I get this "Could not open macro storage" error. I also get the error if I open the new document manually, but the file still opens once I hit OK. Has anyone had any experience with this...

Thanks! I didn't realize there was a difference between Formula and FormulaR1C1. Changing it did the trick though..

When I do this: text = "=subtotal(9," & Chr(64 + col) & "2:" & Chr(64 + col) & lastrow & ")" where col and lastrow are integers, I get an error because it inserts single parenthesis into the formala in the cell. Ex: =subtotal(9,'A20':'B60') Any idea how I get...

When I do this: 'text = "=subtotal(9," & Chr(64 + col) & "2:" & Chr(64 + col) & lastrow & ")" where col and lastrow are integers, I get an error because it inserts single parenthesis into the formala in the cell. Ex: =subtotal(9,'A20':'B60') Any idea how I get...

Thanks! Looking at your code - I realized, the only thing I was missing was the word "Set" in front of the find call. It works now!

Given the name of the column (ie. the text in the header row), I just want to return the column number. Using this code I get an error when nothing is found. dim mycol as variant mycol = ActiveSheet.Range("1:1").find(sort_name, SearchOrder:=xlByRows).Column Is there a better way?

Wow - and to think it sounds like such a simple question! Thanks.

I'm new to forms - how do I use a variable when calling a series of checkboxes. Ex: dim count as integer dim titles(20) as string for count = 1 to 20 titles(count) = myForm."checkbox" & count.caption next count