You might be making this more complicated than you need to. As a programmer, I’m sure you appreciate that when learning a new system, a little time with the help, Google, “Dummies” books, etc. is time well spent. Excel emphasizes a very different programming style than, say, C#. So, here are some options, starting with … Read more
Maybe others will find this useful. I have collected some different functions to generate a short hash of a string in VBA. I don’t take credit for the code and all sources are referenced. CRC16 Function: =CRC16HASH(A1) with this Code hash is a 4 characters long HEX string 19 code lines 4 digits long hash … Read more
Add this at your TODO point: aRange.Columns.AutoFit();
Value retrieved from the cell is already in Unicode. StrConv(vbUnicode) gives you “double unicode” which is broken because it went through a conversion using the current system codepage. Then the Print command converts it back to “single unicode”, again using the current system codepage. Don’t do this. You’re not saving unicode, you’re saving invalid something … Read more
The problem seems to relate to the way Windows handles non-native resolutions on monitors and can be avoided in several ways The problem can be a complete nightmare when it happens, but it only happens intermittently. We have been testing recently an excel worksheet used by a few dozen people and have developed a good … Read more
Kindly use RDBMerge add-in which will combine the data from different worksheet and create a master sheet for you. Please see the below link for more details. http://duggisjobstechnicalstuff.blogspot.in/2013/03/how-to-merge-all-excel-worksheets-with.html Download RDBMerge
Your cells object is not fully qualified. You need to add a DOT before the cells object. For example With Worksheets(“Cable Cards”) .Range(.Cells(RangeStartRow, RangeStartColumn), _ .Cells(RangeEndRow, RangeEndColumn)).PasteSpecial xlValues Similarly, fully qualify all your Cells object.
This code is being used in Excel 2019 64 bit to get the range of the cells on the clipboard as opposed to the contents of the cells. fGetClipRange returns a range object for the Excel range that is cut or copied onto the clipboard, including book and sheet. It reads it directly from the … Read more
Filename is relative to the current Excel directory (which is different from the directory in which an opened document is). You change the current directory by using ChDir “x:\new\path”. But what you actually want to do is: Workbooks.Open Filename:=EnsureSlash(ThisWorkbook.Path) & “myTest.xls”, ReadOnly:=True , where EnsureSlash is your custom function that appends a backslash (\) to … Read more
Dim a As Range, b As Range Set a = Selection For Each b In a.Rows MsgBox b.Address Next