103 reputation
3
bio website
location Poland
age 39
visits member for 1 year, 3 months
seen Apr 28 at 20:16

Hopefully, to help. If not- to learn.


Jun
18
comment Is it possible to have a table with different background colors which automatically update?
this question should be rather asked in SuperUser.Com. However, I think table style feature is what you need.
Jun
8
comment In Excel, How to sort a column and keep respective values in other columns
this is basic excel feature- click B1 and run sorting ascending...
Jun
2
comment Is it possible to save or print a website (google search) via MS Excel (vba coding) as a pdf?
yes, it's possible when using VBA references do Microsoft HTML object library, Internet Explorer and pdf printer like PDFCreator. However, this is rather question to be asked in StackOverflow.
Apr
25
revised How to implement MATCH and INDEX functions together in Excel VBA?
some code improvments
Apr
25
suggested suggested edit on How to implement MATCH and INDEX functions together in Excel VBA?
Apr
15
comment How to change the default language for all slides in a PowerPoint presentation?
It seems that your code is the only good idea. I can't find any property or method which could set language of existing presentation with effect for all text within document. What I find works rather for new presentation, unfortunately.
Apr
11
comment Is it possible to save conditional formatting rules for reuse in a new workbook?
You could store your rules in VBA macro. If you have no experience with VBA try to start recording before you will set CF rules next time. Don't be surprised- if you have complicated CFs that you could result with complicated (but understandable) code. If it is something easy try @JanDoggen link with a bit help of recorder.
Apr
11
comment Excel popup window after using macro
It seems that some data in your sheet a linked to 'Data.xls' file. Possibly, Excel can't find the file when trying to refresh data. Question, what you need to do? Is is allowed to break all links to external files?? Or maybe you could better find that missing file and set the location of it. We advise you accordingly...
Mar
28
awarded  Editor
Mar
28
revised How can I hide column when range is shown (not hidden) in Excel
improvments after comment
Mar
28
comment How can I hide column when range is shown (not hidden) in Excel
Oh, yeah, you right... so, small correction. Thanks!
Mar
28
answered How can I hide column when range is shown (not hidden) in Excel
Mar
28
awarded  Teacher
Mar
21
awarded  Supporter