cont

Hello everyone! I needed to count the unique characters within a range and set up this simple function. I share here for two reasons: 1 - Can be used for someone else 2 - Surely, the masters in excel of this forum will improve it infinitely. Thank you in advance. Public Function...

Hi all I am trying to write a macro that call each cell content of a column in sheet 'A' and past it in sheet 'B' to process some calcs and then to copy the results in sheet C. Below my code. What I would like is to find a way to avoid inputting the last cell of my range (here equal to 31) and...

Hello Guys, I'm running a macro whose purpose is to copy certain ranges over to another worksheet. This used to work flawlessly in Excel 2007/2010, but for some reason it's giving me 'runtime error 1004' in 2013/2016. What's interesting is that part of the same code is executed just fine up...

Dear All, Hi! I have a Master Sheet which records daily entries of calls, contacts, appointments etc, of around four staff. For instance: Calls Cont App Int ... Wed, 6-Mar-19 0 0 0 2 Thu, 7-Mar-19 9 3 1 0 Fri, 8-Mar-19 6 3 0 1 Mon, 11-Mar-19 10 2 0 1 Tue, 12-Mar-19 12 5 0 2 Wed, 13-Mar-19 18...

Hello all, Hoping you can provide some help to a monthly task... I have a table with a list of individuals with a last date of attendance in one column followed by the 12 months. I have provided an example below: <tbody> Name Actual Date Jan Feb Mar Apr May Jun Jul Aug Sep Oct X1...

Hi Everyone, So I was wondering if there is a way to reference thing like sheet names and ranges outside of the macro and still have it know what I mean? for examples This is an example of how I might currently write a macro (I know its not real its for example only) Sub Example1() Dim sht...

Hi, The logical for this code are correct? I need it to repeat the loop until the value of cont is equal to Int(Left(Prazo, 2)) Global rng As Range Global dtData As Range Global crit As Variant Public Function PrazoFinal(DatasAbono As Range, vlrData As Variant) ', Prazo As String...

Hi there! Would anyone be able to help? I am using this formula for the whole year bout after 10 rows it then starts doubling up the value on row one them two etc.... Is there anything I can do or is 8 it? :( I need about 20 active rows...

In a nutshell (does that date me?)... The main macro calls macro A. Macro A calls macro B. Macro B executes to a point. Does not complete. Exits. Macro A does not continue after the call to Macro B. Main macro continues and executes correctly to the end of the program. In my code below: Sub...