Search:

Thanks for your reply!

I guess I will be looking into those options then.
Thanks!

Hello,

I am not sure if this would be better placed in Office Development, as it also has a lot to do with Microsoft Office applications and VBA.

First of all I would highly apreciate some...

Perfect!
Must have over read your post somehow..

Well it works fine now, great help!

Well thanks anyway, I cannot figure out why the order of the sheets is like this, however it outputs the data right and the order of the sheets in the end doesn't matter.

Could you tell me how to...

Okay below you find the necessary extracts of the code regarding the loop.
I name the sheets in the CreateSheet Sub now.

I was using the array to populate the new sheets, as at the top of every...

First of all thanks a lot really appreciate it!

I do not want to copy all the code, because it is really quite alot (surely it can be improved in many places as well) Also the code would...

Thanks for the reply!

If I take this away:

Set NewSheet = ActiveSheet
How does VBA then know what the new sheet is?

About NI, Traffic & ColabsArray:
ColabsArray stands for...

Hello again,

So I made some changes to my code. Yet I still get an error and I was hoping someone could help me.

Quick summary of the situation:
I am trying to copy a Template Sheet from a...

Thanks for the Reply Westconn1, I havnt got time right now to test it but will tomorrow morning. (My time^^) I am working on a Spanish laptop so I am not sure what the exact translation is, but your...

Hello everyone and in advance thanks for your help!

Well, basically I the aim is to copy a model worksheet from one existing Workbook to a new Workbook, changing its name and populating it with...

Thanks guys!
I havnt been online for a while so here is the thanks!

True it does not seem worth doing.

I appreciate your help anyhow!

Anyway I suppose you could do something like this:



Dim aCell As Range

Thanks for the help!

For me that was not too much of a problem as I just had one cell merged with the next. However I wanted to mention it in case someone else would have a similar problem.

I...

Yes my bad, I meant merged cells.

Thanks that works perfectly! Just what I was looking for.

However did you know if you have a combined cell in that worksheet the code outputs a '1004' run-time error? (Works fine just have to...

Thanks for the reply, I found your previous posts regarding the find command. However this does not work in my case.

I even downloaded your example code and changed the look for "Replace me" to "...

Thanks for the reply!

I already revised the code & had a look at yours.

Well basically both codes do not what I am aiming for. As now the clearcontents command seems to be applied to the whole...

hello everyone,

I am stuck on a problem, I want a macro that will look for a cell that has a space or more within and then deletes that cell automatically.
However the Excel sheet is relatively...

Okay I think I just solved the problem. Thanks anyway!

Here I share the fix that worked for me:

I am running Windows 7 64 Bit system and thus downloaded all the ODBC Connectors for the 64 Bit...

Thanks for the reply Chrissy!

Unfortunately I continue to get errors. Here is the correct translation of the last error:



I followed some help on the Internet regarding to create a System...

Hello Everyone,

I have been looking the last half an hour for help & tried varies things to get this working, but no luck. So I hope I can be helped with a new thread.

I want to say previously...

I hope I do not have to open a new thread for this, but I have come across a new error with this and i hope I can get some help on it.

When I run my macro, Excel inserts only 1 row, stops the...

Okay, thanks for the continued help!

Works fine now, I am getting the right answer as well! I guess I needed that explanation.

Thanks to both of you anhn and westconn1!
I am using now anhns...

I can't attach my Workbook.

I am running Windows 7 with Microsoft Office 2007 installed.

I tried it again like this:

=UCountIf(Range, Criteria, ColIndex)

Range = Range of Weeks that are...

Thanks for the help of both of you!

I am however not getting either of them to work for some reason.

The solution of westconn1:
If I run the script as a sub I get
I keep getting A run-time...

Thanks.
If I understood that right would that not require me to place all the names previously in myarr() or not?
In that case I could just make a list of names in Excel and use Excels...

Thanks for the reply westconn1!

After reading your script and revising my topic I realised that I was actually asking for the wrong solution.
I do not need to count unique text values of my...

Thanks for the quick replies!

Yes of course, I'll add the code / sample code that I have so far.
I wrote the thread last night in a bit of a rush. Must have forgotten to add it, sorry.



Can...

Hello again,

I am stuck on a task to count unique entries of a certain range.

I have an Excel table that increases its number of rows every week, as new input is added.
I have one Column B...

Alright here is my promised post:



' Set Formulas
OpenFile = False
' Loop works as pausing the script
While OpenFile = False
FileToOpen = Application.GetOpenFilename...

Thanks for the quick reply, so far helped me alot. I am going to try it out, hopefully I won't require more help, but if some problems occure that I can't solve myself I will post them here.

Once...

Thanks just realised that its in the wrong section, but couldn't find the option to move my thread.

Hello first of all!

I am new to the Forum & I hope my question has not already be solved. But I have to be excused as my specific Problem I have not found using Search.

Summary of the Task:
...