Can anyone help me with this one.....
We have window xp-pro on our PCs.I havnt saved the .pst file since one month in the ms outlook.. and today when i started my ms outlook, i am not able to view my personal folder (inbox, outbox, etc.). Is there any way in which i can find the missing...
Can anyone please send me write-up or anything to say Client-server system is better beneficial over mainframe architecture for small business systems... I am not into IT, and I am finding it difficult to professionally presenting it...
It would be very helpful if i can get any help in this...
Well I have this into the personal workbook. But I copy this code into another computer and copy in that PC's excel personal worksheet. So this should work... but the code is not working.
I think, in the VBAProject(PERSONAL.XLS) the macros that we write are under the module "Modules". If i can override the "Microsoft Excel Objects" module over by "Module" module in this "VBAProject(PERSONAL.XLS)" class module then I will be able to run the...
This hasnt solved the problem.... I think it has something to do with the macro setting.. as it works on one system and doesnt on another... any ideas???
Raj
Thanks ronald for your reply.
This is the complete code i am working on.
Option Base 1
Sub FixedColumnWidth()
Cells.Select
Dim shArr() As Variant
ReDim shArr(Sheets.Count)
For i = 1 To Sheets.Count
shArr(i) = Sheets(i).Name
Next i
Sheets(shArr()).Select...
HI,
I have written a marco in excel but with following code i have a problem.
For Each h In Range(ws.Cells(1, 1), ws.Cells(1, .Column.Count + .Column - 1))
This is part of the marco, which will select for the particular 1st row to find something to do something. But I am getting this error...
In these three lines the use of word "Keyword_Analysis" restricts the macro to run only on the worksheet with the name "Keyword_Analysis". I want the above macro to run on any worksheet with the similar formating. I hope i have made my point clear... I am not very good at...
I have worked it out the whole thing.... Now I have to just make sure that this macro is not specific to any particular worksheet. I mean want this macro to work on any worksheet rather than just Keyword_Analysis. If you can help me on this thing, then it would be great help.
Thanks
Sub...
Its confusing to add these macros as it doesnt work when i run it. I wanted to make it simple so that macros can identify the no. of rows and columns and take that data and represent it into the graph. Sometimes the data might have n row and m columns while sometimes different nos. of rows and...
I dont think I have explained u properly. So i am sending u table as well as the macro.
For the following table, I have written the macro to obtain the graph. But the problem is the no. of column and rows can change as new data comes in... So I dont want to hard code particularly the first part...
Hi,
Can I be able to select a larger graph range instead of B2:F4. The thing is, this graph can vary in columns and rows. Moreover i have to ignore c-column, thats why I have taken as activesheet.seriescollection(1).delete. One more thing - "ABC" is in the first column - not R1C1. Can...
Thanks Skip,
I want to know how u normalise the table which is in unorganised format. This was just my thought (about vector). There can be better ways of doing the normalisation, but how to normalise this table without cut-paste-copy is what i am looking for.
Thanks
Thanks Tony and Skip,
Infact, I will be using this on an ongoing basis... and its not just 3 schools, it will be loads of them in different part of the world....
The thing is, I get this data in form of a set for single school(ABC school, etc.), but the better part is, the variables in the...
Can anyone tell me the macro or some formula that can change the data in sheet1 to appear as in sheet2
Thanks for help
Raj
Sheet1
ABC
In UK
Grade Year Maths Science
1 1991 40 45
2 1992 50 55
3 1993 60 65
4 1994 70 75
5 1995 80 85
6 1996 90 95
7 1997 40 45
8 1998 50 55
9 1999 60 65
10...
Thanks very much Leigh.
But a few problems. First, I want this thing to happen in the header and not in any cell, so the cell reference is a concern. Second thing is, will it work if its ABC_XYZ_Accessories, kind of refernece. Third, Where shall I write this code?? I mean at what place, will...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.