Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Determine PageSetup Zoom Value When Fit To is Selected and related issues
I am trying to determine (xl 2010) what the PageSetup zoom value is when FitToPagesWide is set. I found this 2006 post that describes the problem and a solution that still works. The following code works, thanks to Ron Page but surely there is a better way than using an Excel4 macro? with...- Gav42
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Put a "number" into a cell as a string
Some users are still on earlier versions, sadly. I seem to have actually solved my problem by pre-formatting the cells when the workbook is created. Not worked out how the numeric text gets in ok in the first place as that is part of a different process but problem solved (subject to backward...- Gav42
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Put a "number" into a cell as a string
That worked - thanks! Confused though as this is part of a process that adds a new row into my data table and starts by copying the last row in the table and clearing the contents of cells whose values are to be taken from my userform. My seed row contains numeric strings initially so why...- Gav42
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Put a "number" into a cell as a string
I am trying to put the value that a user has entered in a combo box into a cell as a string using ....Formula = Str(ctrl.Value) However the result is always a number (tested with the istext() function. So how should I be doing it please?- Gav42
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
