QP School

Threads

1. Format cells in a range with bold font and yellow background color (0 Replies)
2. Copy data to another worksheet (0 Replies)
3. Autofill a series of numbers in a column (0 Replies)
4. Loop through columns and clear contents (0 Replies)
5. Sum values based on criteria (0 Replies)
6. Create a hyperlink with VBA (0 Replies)
7. Split text in cells with VBA (0 Replies)
8. Count colored cells with VBA (0 Replies)
9. Calculate factorial of a given number in VBA (0 Replies)
10. Generate random numbers in VBA (0 Replies)
11. Concatenate data in columns (0 Replies)
12. Calculate the avg and color the cells when their values are above or below the avg (0 Replies)
13. Protect specific cells with VBA (0 Replies)
14. Find a specific value in a range and replace it with a new value (0 Replies)
15. Create a pivot table based on data in a worksheet with VBA (0 Replies)
16. Delete rows based on a condition (0 Replies)
17. Filter data in a worksheet (0 Replies)
18. Create a chart from data with VBA (0 Replies)
19. Sort data in a range with VBA (0 Replies)
20. Loop through worksheets and print their names in the immediate window (0 Replies)