excel vba code

My data is set out as below. I have a column for date(A), energy type(B) and 48(B-AX) columns for time (00:00-23:30) with 30 min intervals. The data is set out so that the date is the same for 3 rows(A2-A4), energy type is unique for B2-B4 (W, var, VA) and the range (C2-AX5) contains values...

Hi, Thank you for reading my thread. I am newbie to excel and want to know formula/VBA code for following situation. I have two columns in excel sheet. (Say Column A & Column B). "Column A" Contains list of employees and "Column B" contains list of company. I want to sort company (without...

I want to generate a log while my VBA program runs. Firstly, I initialize the log file and add a title. This works. Then, I want to add info (AddinfoLog). When I open the textfile in MS Wordpad, I see Chinese character intead of "test" on the last row. When I change the 8 to a 2 to write (and...

Hi all, I ve a small query. I need to generate a list of all possible two word combinations from a list in excel containing two columns first name and last name. the first name itself or the last name can be a combination of two or more words. thats why I need a list of all possible two word...

I hope someone can provide me with some help. I realize there are many variations on this question, but I am not finding an answer that suits my needs. My expertise with VBA is basically restricted to finding code in posts that does what I need. I am definitely a beginner when it comes to code...