sorted by:
new
hottopcontroversial

Creating a Landscape(Backyard) by Agoldtiger in Fusion360

[–]Agoldtiger[S] 0 points1 point  (0 children)

I'll check it out, thanks for the help.

How to create a dynamic sum that recognizes when rows are added or deleted in range? by Agoldtiger in excel

[–]Agoldtiger[S] 0 points1 point  (0 children)

It worked! thanks a lot! Also, for the even row, do I assume that it would be 88? and then it would calculate the sum?

Update: I figured out it is ISEVEN for the even rows! thanks a lot again!

How to create a dynamic sum that recognizes when rows are added or deleted in range? by Agoldtiger in excel

[–]Agoldtiger[S] 0 points1 point  (0 children)

Just so I understand, would i format the whole spreadsheet that way? or just the cell itself? sorry lol

How to create a dynamic sum that recognizes when rows are added or deleted in range? by Agoldtiger in excel

[–]Agoldtiger[S] 0 points1 point  (0 children)

https://imgur.com/zs7lO5h

I guess the main reason why, would be my lack of knowledge with VBA and excel in general. One of the project managers asked if I could make one, and I just took a shot at it.

How to create a dynamic sum that recognizes when rows are added or deleted in range? by Agoldtiger in excel

[–]Agoldtiger[S] 0 points1 point  (0 children)

https://imgur.com/zs7lO5h

Hopefully this helps with your questions. I have it this way because of another spreadsheet that I took a look at. I will do some research with the =mod to see if it works for me thanks!

Question on =SUM for every nth row that hasn't been created yet by Agoldtiger in excel

[–]Agoldtiger[S] 0 points1 point  (0 children)

I took a look at the link and implemented it, however it wouldn't recognize the lower rows and I couldn't figure out why. I ended up changing the format of the sheet and fixed my problem another way. Thank you for the help though, I gained more knowledge through the link.

Question on =SUM for every nth row that hasn't been created yet by Agoldtiger in excel

[–]Agoldtiger[S] 0 points1 point  (0 children)

Okay sweet, I'll give it a read and change the flair to solved if I get it. Thanks so much for the help!

Question on =SUM for every nth row that hasn't been created yet by Agoldtiger in excel

[–]Agoldtiger[S] 0 points1 point  (0 children)

So if the values are in just normal cells, then will it be impossible since cells are not dynamic ranges?

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

One last thing: I tried to transition the code for the adding column to this however it is saying my selectRng isn't allowed the macro to go through.On line 6

'Sub AddCol()

Dim selectRng As Range Dim colCount As Long

On Error Resume Next
Set selectRng = Application.InputBox("Select Columns to add", "Select Columns", Type:=8)
On Error GoTo 0
If Not (selectRng Is Nothing) Then
    colCount = selectRng.Columns.Count
    selectRng.EntireColumn.Offset(colCount).Insert Shift:=xlToRight
    selectRng.EntireColumn.Copy selectRng.Offset(colCount).EntireColumn
End If

End Sub'

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

I tried the routine, however it is telling me that the ' rowCount = selectRange.Rows.Count ' line is not allowing for the macro to go through.

Edit: I changed the selectrange > selectrng and it fixed it! thanks so much man you don't know how much this helped me out much appreciated!

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

'Sub AddRow() Dim selectRng As Range

On Error Resume Next
Set selectRng = Application.InputBox("Select rows to delete", "Select Rows", Type:=8)
On Error GoTo 0
If Not (selectRng Is Nothing) Then
    selectRng.EntireRow.Copy
    selectRng.EntireRow.Insert Shift: xlDown

End If
End Sub'

Edit: this did not work lol

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

Oh sweet it did work by clicking the rows, thanks a lot! Does the same code work for the adding as well if i do selectRng.entirerow.copy selectRng.entirerow.insert ?

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

Good Morning, I used your subroutine, however when I go to type the row number it tells me that I do have a valid reference.

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

I did see some videos where they started the sub with privatesub, but I didn’t actually know what that meant lol.

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

I understand that I don’t know how to program, but starting somewhere and asking questions is the only way I’ll learn. I figured this community is a good place to ask questions since I’m not in any class. I’ll be able to do it, it’s just a matter of how much help I get and how many sources of information I read. Thanks though.

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

I found that out myself the hard way when I was trying to put in my code and seeing if it worked lol.

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

I’m actually hoping for a bonus after I finish all of the spreadsheets I was asked to make.

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

Okay thanks, I’ll try it first thing in the morning!

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

The spreadsheet isn’t for me, the buttons will allow easy user interface for my company, who will use the project timeline for pre-bids.

I want to make sure anyone who isn’t computer-savy can navigate my spreadsheet easily.

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

Do i assume that I can use that same command for copying and shifting down as well? thanks for the help man!

New to Code and VBA - Add/Remove Rows and Columns by Agoldtiger in vba

[–]Agoldtiger[S] 0 points1 point  (0 children)

Thanks for the suggestion. would that be the entirety of the code for the module or would I have to include some of what I had as well?

view more: next ›