vga

Hallo Zusammen, ich musste für die Arbeit ein Makro programmieren, dieses funktioniert einzeln auch. Nun habe ich das Problem, dass in dem Excel schon ein anderes Makro mit "Worksheet_Change" existiert, welches nicht von mir ist und mir die Funktion nicht bekannt ist. Wenn ich Beispielsweise...

Hi everyone, I need a Macro that populates a range of cells with a formula. At first, I thought this would be an easy problem... but I'm starting to think that it is a more advanced problem than I originally guessed. To explain: In my spreadsheet, I have two sheets: PERM_DATA and...

Hi I'm trying to figure out how to insert a page break on every column no matter the amount of columns.

Hello, I'm new to VBA. I'd want to insert a row under in two columns only using "yes"/"no" option buttons (as shown). When "yes" is selected a new row will be created. If "no" is selected then the created row will be deleted. Hoping for something simple enough that can be modified & used...

I am working on a workbook that will contain a form for me to fill out regarding customers. I have completed a blank form and I have used a second worsheet to have a blank copy of the form and on worksheet1 is where the worksheet will go where I will fill out. I have worked on a macro where when...

Hi all, I am trying to hide/ unhide columns based on a 'Yes' / 'No' data validation list on another sheet. The first sheet has a number of drop down lists, all with a yes/no outcome, I would like selected columns on a 'Tracker' sheet to be visible when the outcome is 'yes' and hidden when the...

Hi everyone, I am new to VGA, but I really need to get this button to work. I have a sheet with different tables. In my second table, I have 4 rows and 2 columns. The first column says 1st, 2nd, 3rd, 4th, and the second column is blank (besides having a thick border) for the user to fill in...