Search For:

Hi Gurus,

Quick help with an array related VBA problem. I have a table with information on what classes are assigned to a Teacher.

Classes Teacher
1 Ravi
2 Kiran
3 ...

Thank you very much Nicolas. This is very helpful. I learnt the lesson needed. I hope I'll be able to apply it now.

Regards,
Ravi Kiran.

Hi Gurus,

I have a query about using Array Variables in excel VBA. I have a set of lookup tables and a main data table. The data table will be downloaded everyday. I need to replace the ID's in...

Thank you very much Stephen! I tried understanding the formula :( but no use. Though I am able to adapt it to my table :)

If you got some time, can you please explain how the formula works.
...

Thanks for you reply Stephen.

That would be ideal. But I will be satisfied with 3 values supposed to be topped the whole list. I spent considerable amount of time modelling the table. But am stuck...

Dear Gurus,

I need to create a chart from a table with the Top 3 values in the series.

Please find the info in the below image.

48226

So when Class 1 is selected, the values in the Table...

Thanks Jindon, this code worked awesome. Thanks again.

Regards,
RK.

Thanks Jindon. I am checking out to customize the code.

There are few titbits I didn't understand. What is "Scripting.Dictionary"?

And where do I copy my script to extract the relevant data (if...

I run a script in a loop for several records (Orders). The loop works fine. But the problem is, sometimes there are duplicates. Processing time for each record is high and having duplicates is...

Thanks. But I need two formulas. One to copy the Values and another to copy the respective vendors as well :)

I'll try to figure out. But would be helpful, if you can post the solution.
...

Dear Gurus,

Need some help with this issue. I have a list of vendors who enter their sales data in an excel spread sheet. I need to isolate the top four and create a separate list using excel...

I do use European Date system. And the time&date settings are correctly configured to UK on my system. I did trouble shoot that.

There must me some other explanation, why the date is being...

Dear Gurus,

I have a problem converting a column containing datetime values as text.

="06/07/2012 00:00:00"
="06/07/2012 00:05:00"
="06/07/2012 00:07:00"
="06/07/2012 00:09:00"
="06/07/2012...

Dear Gurus,

I need help from an MSDN Guru :) My question is: Is there a way to point excel to an open webpage and it extracts the required data from the page?

Detailed explanation:

My client...

Bump!

Guys, can anyone help me with the VBA Code for this?

Thanks,

Regards,
RK.

Sorry NBVC, this doesn't work forme.

I am not sure formula approach will work for me. I am looking out to write a VBA code for this feature.

Any assistance with this code will be of great...

Dear Gurus,

I have a complex issue to be solved (complex enough for me at this moment) :)

I have a list of records with Date and Time, from this we need to scan through the time and pick those...

Dear Gurus,

I need to reference a cell and conditionally format another cell. There are 3 conditions that I need to apply. I have some problem with the syntax, esp, where I need to refer if text...

Thanks for the help. I got it working.

Regards,
RK.

Thanks Jindon. That's helpful. But the issue is I am unable to use dynamic rows in that syntax :)

Can you help me with that as well taking the active row as cRow?

Thank you,

Regards,
RK.

Dear Michael,

Let me clarify my position.

I am trying to copy data from 1 huge table and create few table based on different criteria. The problem is that the initial table is huge (1000s of...

Hello Friends,

I have this weird requirement in VBA, where I need to copy multiple sections of a range (single row), but need to paste it as a continuous range. I mean the following e.g.:


...

Thanks Cytop. I exactly followed the instructions. Hope the issue gets fixed :) Thanks very much.

Regards,
RK.

Dear Excel Gurus,

Can anyone please explain the meaning of this error? I am getting this error in a workbook that I developed. I used CustomUI Tabs in the workbook.


45239

In very rare...

Yes Clarity. That seems to be a good approach. But my idea behind this exercise, is to make it simple for the End Users (who doesn't understand a IF condition and be able to modify it). And there...