VBA code to repeat formula in next cell

[vipul_patel23111]

Hi ,

I got stuck in VBA code
I want to repeat formula in next cell
also, want to check left side cell if it is empty then stop macro

Appreciated your help

 

[hiker95]

vipul_patel23111,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

3. Can we see your macro code?


I would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com


If you are not able to provide screenshots, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com


When posting VBA code, please use Code Tags - like this:

[code=rich]

Paste your code here.

[/code]

 

[vipul_patel23111]

I'm using MS office 2013, Windows 7
PC

 

[vipul_patel23111]

Private Sub CommandButton1_Click()
With Sheets("sheet1")
.Range("D3:D" & .Cells(.Rows.Count, "C").End(xlUp).Row).Formula = "=sum(B3:C3)"
End With
End Sub

 

[hiker95]

I got stuck in VBA code
I want to repeat formula in next cell
also, want to check left side cell if it is empty then stop macro

vipul_patel23111,

In order to find a macro solution to solve your request, I would like to see a screenshot of the raw data, and, a screenshot of the results (manually formatted by you for the results you are looking for).


See reply #2 at the next link, if you want to show small screenshots.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


If you are not able to provide screenshots, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.