View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default macro for deleting cells trought column A

See inline comments...

I dont understand what need to change in

Const DataStartRow As Long = 3 - this dont understand


Put the row number of your first piece of data in the DataStartRow constant.
For your posted example data, that would be the row number where "ALBANIJA
211" is located. I don't know your layout (do you have header rows for
example... if so, do you have a blank separating row between your header and
first piece of data?)... so you have to tell the code where your data is.

i need individual sums per country and then delete unwanted country's.
need only summation and one country


But where do you want these sums to go? In an array in memory? On the
worksheet somewhere? If on the worksheet, where (what column and/or row)?

And what do you mean by "delete unwanted country's"? What makes a country
wanted or unwanted?

--
Rick (MVP - Excel)