User Profile
g_keramidas
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Pasting column width issue
not sure if this started happening with version 2414 build 18324.20168 or not, but if i filter a table and copy it, then paste the copied cells as values to another sheet or workbook and then do a subsequent pastepecial and choose column widths, the data is deleted. can anybody repro?90Views0likes1CommentRe: Dev Channel update to 124.0.2478.6 is live.
keeps crashing. won't even run long enough to post this. and therein lies the probelm with this app model. it sucks. no way to go back to a working version. at the mecy of the developer to realize there's proble, fix it, and then post the update. did i say this app model sucks?4KViews0likes0CommentsRe: Dev Channel update to 112.0.1722.7 is live
you may have fixed these, but the collections button is still not displayed on the toolbar. i've disabled, enabled multiple times. it does not display. Fixed website opening twice from Collection when using the middle mouse button Fixed Collection not displaying thumbnails.17KViews1like0Commentsvba to return results of filter function into an array
i'm wondering if this is possible. i currently have to enter a formula in a cell and then work with the date in that range. i can get the results of the unique function into an array, but not the filter function can this be accomplished? thanks Gary example in vba Sub test() Dim arr As Variant Dim arr2 As Variant ' this works arr = WorksheetFunction.Unique([Table1[Line]]) 'this formula in a cell returns data, if empty excluded for simplicity '=FILTER(Table1[Line],Table1[Form_Num] = 4) 'this pops a type mismatch error arr2 = WorksheetFunction.Filter([Table1[Line]], [Table1[FORM_NUM]] = 4) End SubSolved3.4KViews0likes4Commentsusing vba to enter a unique function formula
i can enter a simple formula in a cell and it works fine =unique(items[item]) if i use vba to enter the formula, it does not spill and only A1 gets filled range("A1").Formula = "=unique(items[item])" =@UNIQUE(Items[Item]) it has the @ sign in the formula, which isn't supposed to affect anything. but, if i edit the cell and remove the @ sign, the results spill correctly. can vba be used to enter a formula like this? or, can the results be stored in an array and then written to the spreadsheet? i can put a single column of unique values into an array, but not into a multi-dimensional array when there are multiple columns. this works using a table named Items with columns item and description: Dim arr As Variant arr = worksheetfunction.unique([Items[item]]) this does not arr = WorksheetFunction.Unique([Items[item]:[description]]) thanks GarySolved11KViews0likes2Commentsexcel crashes when sending feedback
after installing Version 2203 (Build 15028.20228), excel crashes when sending feedback Description Faulting Application Path: C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE Problem signature Problem Event Name: APPCRASH Application Name: EXCEL.EXE Application Version: 16.0.15028.20228 Application Timestamp: 625f1161 Fault Module Name: ntdll.dll Fault Module Version: 10.0.19041.1566 Fault Module Timestamp: 1be73aa8 Exception Code: c0150014 Exception Offset: 00000000000adaa4 OS Version: 10.0.19044.2.0.0.256.48 Locale ID: 1033 Additional Information 1: c3af Additional Information 2: c3afcbf1a52027615e306179a7c8ffb5 Additional Information 3: 95b4 Additional Information 4: 95b4b56303e28bf0d3fdf77cc11dc85f Extra information about the problem Bucket ID: f8156fed34d043ad5ffaced512724e04 (2304381573886266884)681Views0likes1Comment
Recent Blog Articles
No content to show