thread

Hi all, For reasons beyond my manipulation, I am making - or trying to make, a forum type solution to be used on a LAN with MS Access. I do know many web solutions exist, and I have utilized quite a few, but those cannot be used in my current project so please don't tell me about all the...

Hello I found the following code on another thread: Sub Delete_Last_10_Rows() Dim rLastRow As Range Set rLastRow = Cells(Rows.Count, "C").End(xlUp) 'now delete last 10 rows: rLastRow.Offset(-9).Resize(10).EntireRow.Delete MsgBox ("The last 10 Sets of Data is now Deleted") End Sub Many...

Hi All. I want to fill Combobox with For Next, and here's an example of my code for i = 1 to 5 ComboBox1.additem i next i somehow, the output is not what I want it to be. should be 1,2,3,4,5 instead of 5 Can someone help me Thank you in advance sorry if thread like this, ever discussed in...

Can someone please help me? I'm using the 2017 version of HTML Maker but it seems to ignore the formatting I use in the worksheet. When I preview the thread prior to submission, the formatting is fine, but when I submit, it disappears. Also, the Excel frame of column headings and formulas used...

Lost a new thread post - where do auto saves go? i answered the phone after three minutes went back and posted by question but it's not anywhere to be seen. Looks like my session timed out. But I always see the auto saved popup - so where do I go to find the original post?

Hello, Looking around I couldn't find any way to do it, but maybe i'm not looking at the proper place, is there a way to tag a thread as solved so other members can identify the issue as solved ? Thanks Matthieu.

Hi all, Hope everything is fine. Just to avoid duplication, I am just sending you the link (as mentioned below) where the post / thread is located. There is attachment of the excel file for better explanation. Can 'IF' condition be applied to the same Cell which already has value in it ? Can...

Hi there. I include a rendering of my data at the end of the post. SCROLL WAY DOWN. I have a novel problem. I must regularly generate indices of various documents exported from a database. These consist of emails and their attachments, as well as other documents mixed in that are not...

<TBODY> Hi All This is some data I extract from a report, the data appears all in one cell (A1): 0:0 (0.00%) 1:0 (0.00%) 2:0 (0.00%) 3:0 (0.00%) 4:0 (0.00%) 5:0 (0.00%) 6:1 (3.85%) 7:3 (11.54%) 8:11 (42.31%) 9:11 (42.31%) What I would like to do is use a formula to calculate a net promoter...

Hi Guys! I've created a vba macro that formates the excel sheets in some defined format. It runs quite smoothly. But then as soon as I shift the focus to some other application the performance drastically reduces. Normal run time of 30 minutes is extended to over 2 hours. The application is...