| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro adds "=" to each cell in defined range across multiple worksheets
"abbruno" wrote:
I am getting a compile error (For Each control variable must be variant or object) Can you please tell me what is wrong and how to fix this? My bad! Sometimes I forget VBA's subtle foibles. Fix this problem by changing the type of shName from String to Variant. That is: Dim shName As Variant I did not sanity-check the rest of the code. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Worksheets("Sheetname").Select refuses to kick in from User Defined function | Excel Programming | |||
| Cell "A" Adds data to Other Cells | Excel Discussion (Misc queries) | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
![joeu2004[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
