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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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
514
ob1tech77
O
C
  • Solved
Sum referenced cells in Sheet range using SUM(INDIRECT()) #REF! ERROR
2
Replies
12
Views
328
Fluff
Fluff
F
  • Question
Formula to insert a picture based on various cell values, w/out VBA, Macros, etc.
Replies
4
Views
268
Domenic
D
G
  • Question
VBA: Referencing a named range
Replies
4
Views
139
rlv01
R
N
  • Question
copy value from another sheet when making a new one, and keep the reference to that cell
Replies
3
Views
370
rlv01
R

Forum statistics

Threads
1,216,122
Messages
6,128,958
Members
449,480
Latest member
yesitisasport

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