Referencing range of cells one by one in every 4th cell (VBA)

Q

qasimmalik

New Member
Joined
May 15, 2018
Messages
7
Hi, I needed some help writing VBA.

I need to reference a range of cells one by one from sheet 1 (cells are in the range A2:A2357) to every 4th cell of column D in sheet 2, starting at D2.

Please let me know how I can solve this. Thank you in advance for your help.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

O
  • Solved
Save PDF's from a dropdown menu using VBA
2
Replies
12
Views
349
ob1tech77
O
C
  • Solved
Sum referenced cells in Sheet range using SUM(INDIRECT()) #REF! ERROR
2
Replies
12
Views
202
Fluff
Fluff
F
  • Question
Formula to insert a picture based on various cell values, w/out VBA, Macros, etc.
Replies
4
Views
112
Domenic
D
N
  • Question
copy value from another sheet when making a new one, and keep the reference to that cell
Replies
3
Views
327
rlv01
R
N
  • Question
Count a value in a cell (within a specified range) every nth cell along the row
2
Replies
17
Views
548
KRice
K

Forum statistics

Threads
1,214,920
Messages
6,122,264
Members
449,075
Latest member
staticfluids

Share this page

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
Back
Top