Posts by ecodata • 37 points
4 posts
-
0
votes1
answer58
viewsQ: How to generate a report from a recorded macro?
Good afternoon to you all, I recorded a macro to generate a report from a spreadsheet that I am feeding with data. Basically the macro will create another workbook in the same worksheet and paste…
-
0
votes1
answer108
viewsQ: How to create a chart with the last row data automatically when closing the form?
I’m making a VBA form with information about some municipalities (that are in Combobox) and their respective goals to be hit (which is like a direct formula in the spreadsheet). In the form I insert…
-
1
votes1
answer2720
viewsQ: VBA - How to send specific cells of a spreadsheet in the body of an email
Hello, I’m trying to make an application for my work in VBA, however I’m having difficulty sending only some cells in the body of an email directly via outlook. Private Sub CommandButton1_Click()…
-
2
votes1
answer3034
viewsQ: How to customize the x-axis of a graph with two y-axes, for text?
I would like to know how I change my x-axis from a graph with two y-axes, because I want to give the x-axis names of Brazilian states. numpy_matrix = df.as_matrix() x = numpy_matrix[0:,0] y1 =…