Mac Tips – Deleting Bookmarks From Firefox

Mac Tips – Deleting Bookmarks From Firefox One thing I’ve seen many people (including myself) searching for is how to delete a bookmark you have made in Firefox. If you have placed this bookmark within a folder on the bookmark menu, you cannot simply right-click on it and delete it when you want to remove…

Read More

Excel VBA Tips: Convert Number to Text

Excel VBA Tips: Convert Number to Text I have covered how to do this using worksheet formulae, but it can also be done using vba. If your variable (that is a number) is called Number, to convert this to text, use the following code: Number = CStr(Number) It will now be stored in text format.…

Read More

Excel Worksheet Tips: Keyboard Shortcuts

Excel Worksheet Tips: Keyboard Shortcuts I was searching for a particular shortcut but unfortunately I was unable to find the one I was looking for; however I have found many more. Check out all these useful shortcuts here. Come check out the directory for the rest of my excel tips! Submeg IT

Read More

Excel VBA Tips: Closing All Non-Active Workbooks

Excel VBA Tips: Closing All Non-Active Workbooks If you ever need to close off all the workbooks you have open in the background but don’t want to have to navigate to each one, this code is extremely useful. Public Sub CloseAllInactive() Dim Wb As Workbook Dim AWb As String AWb = ActiveWorkbook.Name ‘Your code here,…

Read More

Mac Tips – Take screenshots on a Mac

Mac Tips – Take screenshots on a Mac Unlike windows, there is no button for taking screenshots. To perform different screenshot types, see the list below: Command-Shift-3: Take a screenshot of the screen, and save it as a file on the desktop Command-Shift-4, then select an area: Take a screenshot of an area and save…

Read More