VBA code to repeat formula in next cell

vipul_patel23111

New Member
Joined
Mar 9, 2016
Messages
3
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
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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

New Member
Joined
Mar 9, 2016
Messages
3
Code:
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

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,328
Members
414,054
Latest member
Sameer50

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top