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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copying a Style from a template w/o Copying Fonts
Use the Font property use a variable to assign the current font style to it ActiveDocument.Select fontname = Selection.Font.Name Then when you copy and paste from the template With Selection .Font.Name = fontname End With Rich- finanl
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
trouble with add-in
Luis, I still am not exactly certain what you are trying to do but the following code will create a custom menu for you and I would suggest, like Rob did, to put your macro within the Add-In, make it a different module within the add-in. The last bit of code starting with Private Sub...- finanl
- Post #16
- Forum: VBA Visual Basic for Applications (Microsoft)
-
XL97: Cell.Formula ignores leading single qote?
I know this may not be the cleanest way to do this but you could add the ' to the front. Range("A1").value = "'some string" Set c = Range("A1") x = "'" & c Not the most favorable way but will work Rich- finanl
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Selecting Rows in Excel
Change Rows("RValx:RValy") to Rows(RValx & ":" & RValy) and it should work fine Rich- finanl
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
AutoExec command
Create a module with the code below and name it Test. Create a macro with the name of AutoExec. In the macro design screen, choose RunCode and at the bottom under Action Arguments in the Function Name type in AutoExec(). Save the database file and then open it back up. Your message box will...- finanl
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
